Robert, You're saying that even inside a transaction this doesn't work? Which DB's does this fail on? We do this all the time and I've never seen a problem. If this has in fact been a known issue since T3, I'd have to say I'm disgusted with Pervasive to no end. This bug renders this product useless as far as I'm concerned. Hopefully, With has fixed or will fix this in thier version.
Mike Robert Sfeir wrote: > -----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 -- Mike Tyranski Lynch2 p: 847.608.6900 f: 847.608.9501 http://www.lynch2.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
