Markus Ostenried wrote:

> looks like Sean answered faster than me.

And me ;-)

> Here's the documentation for what you want (search the page for "Our last
> example"):
> http://www.firebirdsql.org/refdocs/langrefupd20-execblock.html

Ha! Could have referred to that. I admit I was too lazy to give an example in 
my reply - totally forgot I wrote that one.

One thing though, Piotr: if your Firebird client doesn't support input 
parameters on executable blocks (like isql), you have to write an SP. But this 
is hardly more work, and it has the additional advantage that, once written, 
you can call it from any number of places in your code. The executable block 
would have to be copied over and over again (or included in a programming 
language function/procedure/macro).


Paul Vinkenoog

Reply via email to