Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 11
- Joined: Tue 17 Jan 2006 11:32
I use TMSStoredProc, after inserting, i would like to get SCOPE_IDENTITY.
But i couln't. How can i get this record's identity ?
- Posts: 512
- Joined: Thu 26 Jan 2006 10:06
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.