Subject Re: [firebird-php] insert_id() for Interbase/Firebird
Author Milan Babuskov
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.

Milan Babuskov