Re: [Firebird-devel] Simplify MySQL migration: LAST_INSERT_ID()

[Milan B. <mi...@pa...>]

Roman Rokytskyy wrote:
> For LAST_INSERT_ID(), the most recently generated ID is maintained in 
> the server on a per-connection basis.

Wouldn't adding a simple line to auto-increment triggers do the same?

create trigger
...
new.autoinc = gen_id(some_generator, 1);
RDB$SET_CONTEXT('USER_SESSION', 'LAST_INSERT_ID', new.autoinc);
...

-- 
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================