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

[Martin S. <mse...@gm...>]

On Saturday, 25. December 2010 22.58:53 Roman Rokytskyy wrote:
> Hi,
>
> I am trying to port Joomla CMS to Firebird (just started, so no progress
> here), but I found that it uses one feature that MySQL has in regard to
> auto-increment columns.
>
> Excert from the docs:
>
> "When a new AUTO_INCREMENT value has been generated, you can also obtain
> it by executing a SELECT LAST_INSERT_ID() statement with mysql_query()
> and retrieving the value from the result set returned by the statement.
>
[...]
In MSEgui we use either a tsequencelink which queries a generator to provide 
the ID value for an inserted record or we use the RETURNING clause of the 
INSERT or UPDATE statement in order to update the datatset field value of the 
inserted or modified record automatically.

Martin