Subject | Looking for answer on ADO/ODBC Auto_Increment Return Value |
---|---|
Author | Chris Thornberry |
Post date | 2005-01-02T23:31:45Z |
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
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