Delphi 2005, mssql server 8 Asp .net application
I need to get the new identity value returned after doing an insert into.
t into mytable (myfield1,myfield2) values (?,?)'
scop_identity() as ID'
But I only get 0 as myid, ie the new identity value is not returned.
Any hints how to get the identity of a insert into statement?
(I figured it out how to do it if you insert a new record into a grid reading an article
, but now I am inserting one records from a web form)
I also tried with the following statement without results:
while aread.read do