Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: Value of autoinc field after applyupdate

Permlink Replies: 0 Threads: [ Previous | Next ]
Raúl Toledano

Posts: 2
Registered: 6/22/06
Value of autoinc field after applyupdate
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 15, 2016 3:52 AM
Rad Studio XE5

I'm using TSQLQuery, TDataSetProvider and TClientDataset to manage a table with an AutoInc Field

I need to obtain then new Identity value after apply updates to do others inserts in a child table with a foreing key before commit or rollback transacction.

My DataBase is SQL Server

I'm using SELECT SCOPE_IDENTITY() but null value return. I can't use @@IDENTITY because the master table have a trigger

Thanks and sorry for my english
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02