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

[Adriano d. S. F. <adr...@gm...>]

On 25-12-2010 19:58, Roman Rokytskyy wrote:
> 
> We do not have the AUTO_INCREMENT data type, but I was thinking that for 
> the most use cases (80/20 principle), storing the last value used in the 
> gen_id(..) function in the context would do the trick.
> 
I'd much prefer something like LAST_GEN_ID(<name>). Oracle has
<name>.curval, so it's like something a database-portable application
would be capable to use.


Adriano