Tom, Typically we:
Begin Transaction Insert Record Retrieve Highest Identity Close Transaction Robert Shubert Tronics Thomas Ferguson wrote: > > nevermind... since it was an autonum, I just retreived the last row and > extracted the key. > > Any idea on how to do this without an autonum and no date/time stamp? > > Just curious. > > TIA > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas Ferguson > Sent: Tuesday, August 27, 2002 6:06 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Key of Record Just Written > > I know I've seen this before, but I can't find it in the archives... > > How do I get the value of the key of the record I just wrote? I'm using MS > SQL with the key defined as an AutoNum (Identity). > > Thanks in advance > > Top Ferguson > ARiSAR, Inc. > > 727.577.7474 - Office > 727.577.7494 - Fax > 727.510-9863 - Mobile > > www.arisar.com > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
