Subject Re: [ib-support] Re: getting the generated ID
Author Woody
From: "zifnabbe" <zifnabbe@...>
> What is the function to retrieve the ID which is inserted by the
> insert stored procedure? Or do you mean, creating a stored procedure
> which calls the GEN_ID itself and thus not using the before insert
> trigger?

Select gen_id(generator_name, 1) from rdb$database

Both IBO and IBX have a way to specify the generator and the field and they
will automatically do this for you when you insert a new record.