Subject Re: [firebird-support] Get Gen_ID value used in last INSERT INTO
Author Bogusław Brandys
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

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

Bogusław Brandys