[thelist] Key ID of Record Just Created?
Chris Hayes
chris at lwcdial.net
Tue Aug 23 16:30:11 CDT 2005
>> DIM valDocID as Integer = SELECT @@IDENTITY
>
> I don't know anything about .NET syntax, but basically yes, you will have
> to
> run that SELECT query, and assign the results to a variable
Don'y know if it applies to ASP with MS/MY SQL but might advise a
transaction lock around the insert and the select to ensure you retrieve the
correct ID.
Anybody?
More information about the thelist
mailing list