0

I want to run a Firebird stored procedure from a batch file or similar on a desktop. The stored procedure contains insert statements and update statements with if possible parameters that I would like to pass.

Any ideas or other suggestions would be appreciated.

mghie
  • 31,279
  • 6
  • 82
  • 123
Mark
  • 1
  • 1
  • Use mghie's advice on how to call EXECUTE PROCEDURE from an SQL script. If your stored procedure happens to use "suspend" then combine with Hugues Van Landeghem's (because in that case you need to FOR SELECT) – Cosmin Prund May 21 '10 at 05:48

2 Answers2

1

There is a Firebird isql tool, it even has a link in the start menu group. You can use this in your script. For the syntax see for example Stefan Heymann's site.

mghie
  • 31,279
  • 6
  • 82
  • 123
1

I think you can also try the EXECUTE BLOCK syntax

Hugues Van Landeghem
  • 6,694
  • 3
  • 29
  • 55
  • +1 because without EXECUTE BLOCK you're limited to simple operations (INSERT / DELETE / UPDATE & Metadata Manipulation) – Cosmin Prund May 21 '10 at 05:46