Devart Forums

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

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.