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.

HTH
Woody