Lester Caine wrote:

> While I can see the uses, I'm not sure we want to 'propagate bad
> practice' ;)
> If you need the number back, then you probably needed it before you
> started the inserts
>
> Most Firebird users have had the 'proper' way of using generators
> drilled into them, and the ADOdb actions for gen_id() to get the next
> number first is always preferable.
>
> The CORRECT fix for this will come with Firebird 2 when RETURNING is
> implemented, and ALL the trigger generated fields can be accessed.

FWIW, I support Lester's opinion on this completely.

Regards,
--
Milan Babuskov
http://fbexport.sourceforge.net