Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 11
Joined: Tue 17 Jan 2006 11:32


Post by haci » Wed 02 May 2007 08:31

I use TMSStoredProc, after inserting, i would like to get SCOPE_IDENTITY.
But i couln't. How can i get this record's identity ?

Thank you

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Thu 03 May 2007 13:01

Do use you SDAC SQL Generator to generate the INSERT statement or you have provided your own statement?
If you use SDAC SQL Generator, check that the value of the TMSStoredProc.Options.QueryIdentity property is True and you have INDENTITY columns in the result set.

Post Reply