Subject Re: [firebird-support] Looking for answer on ADO/ODBC Auto_Increment Return Value
Author Helen Borrie
At 06:31 PM 2/01/2005 -0500, you wrote:

>Greetings list,
>I am currently having a problem with an application I am working on. I need
>to return the primary key value (generated by a trigger/generator/procedure
>combination) of the newly inserted record.
>I am using ASP (with VBScript) and ADO/ODBC to connect to my firebird
>database. After countless hours of searching online I found a command
>"SELECT @@IDENTITY" for MSSQL to retrieve the value, but wonder if there is
>a similar command for Firebird or another work around.
>Thanks much in advance.

The trick is to get it *before* you post the insert. There's an FAQ on the
website that tells you how to do it.