Problem with SELECT @@IDENTITY query

  • Thread starter Thread starter Sameer Motwani
  • Start date Start date
S

Sameer Motwani

Hi,
I tried using the query SELECT @@IDENTITY to retrieve the Identity value of
a record after inserting it in a Replicated Access 2000 database but it
always returned 0, the Primary Key field in my table is of type Guid (not
Autoincrement).

Does anyone has any suggestions as to how I can retrieve the Guid ID value
from the Inserted Record

Thank You,
Sameer
 
As I understand it your app should set the GUID and include it in the Insert
statement.
Then you do not even need to get it back.
That is the big advantage to a GUID - you already know it.
 
Back
Top