TMSStoredProc & SCOPE_IDENTITY

haci · 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

Jackson · 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.