Diego Barros wrote:

>
> When I insert a new row into a table, and one of the field's uses a
> generator, how can I get that value of that generated field? Do I need
> to write a stored procedure to do this? Something like:
>
> ID = GEN_ID('xx', 1);
> INSERT INTO Table... (using ID)
> return ID

This is commonly used I suppose.

> Or is there something along the lines of SQL Server's "SELECT
> @@IDENTITY"?

Not the one I know.Probably such special SQL notexists for Firebird.


Regards
Bogusław Brandys