Subject Looking for answer on ADO/ODBC Auto_Increment Return Value
Author Chris Thornberry
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.

Regards,
Chris