> I am trying to load a database with data via a sql script. All the
> loading is done by stored procs that return the ID of what it just
> inserted. I catch wind of "execute block", which looks like it might
> allow me to capture the returned ID in a variable to use it in the
> next call. I looked in the IB 7.5 help and cannot find anything about
> "execute block" specificy. Am I understanding the concept of execute
> block? If so, is my impression correct that it is not aviable to me
> in IB 7.5?

1 - AFAIK, EXECUTE BLOCK is not supported in any IB version, period.

2 - EXECUTE BLOCK is a Stored Procedure without being "stored". So, you can do anything you want inside the block.

3 - There are no variables in a database script; each statement stands on its own. You can't pass the results of one statement to later statements in the script.


Sean