Being paranoid, I set a variable to <@CURRENTTIMESTAMP> and I insert both the Timestamp Var **AND** the <@USERREFERENCE> That combination will always yield something unique. If you have a busy site there could be multiple people doing the same action and you could retrieve someone else's Numeric key. That is why I always use this combination.
Jose on 8/27/02 6:48 PM, Thomas Ferguson at [EMAIL PROTECTED] 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 -- Webologies 150 Robinette Drive Waynesville, NC 28786 828.627.1994 http://www.webologies.com ---------------------------------------------------------------------------- Rocket J Squirrel "Captain Peachfuzz has suddenly turned stupid" Bullwinkle J Moose "That wasn't a turn, it was more of a slight veer" ---------------------------------------------------------------------------- ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
