> -----Original Message-----
> Is there an example of a stored procedure to retrieve the
> unique key created by a trigger on insert at the same time as
> the insertion is done? ( hope this is the correct list now .. )

If you are interested in this, then I would recommend you use a stored
procedure, that:

1. Grabs the next id
2. Inserts the record
3. Returns the id

If you want help writing these functions you can use a little utility I
wrote called SPGen
(http://sourceforge.net/project/showfiles.php?group_id=136873&package_id=172
073) which will automatically create these types of procedures for your
database.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum