-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 yes but unfortunately, the transaction blocks in Tango 4 don't work right. Not WithEnterprises' fault, just something that has lingered for a long time in T3/T4, and depending on the DB you're still not assured that you get the right ID since you could be inserting from another taf to the same table, and since you're obviously not table locking, you're not guaranteed an ID.
R On Tuesday, August 27, 2002, at 07:02 PM, Robert Shubert wrote: > 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 > Robert S. Sfeir Senior Java Engineer PGP Key available at: pgpkeys.mit.edu KeyID: 128C88C7 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (Darwin) iD8DBQE9bA07AP6i6RKMiMcRAqIbAKCvvgEoEFMe/UA3LwCuiwB1CVHPrQCglLtF oDUO4/MuFoQKnGCQDBx8hzQ= =B91s -----END PGP SIGNATURE----- ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
