Robert, The suggestion was made knowing that Tom is using MS SQL which would handle the transaction properly. You're right that blocking is an issue with T2K, although somewhat controllable with a well written dsconfig.ini. W5 does seem to work better, well, it removes blocking altogether, so the DB has to know what's going on. One other point, you can set the numconnections to 1 (I think that's the parameter) and effectively activate blocking within Tango by deafult of allowing only one active connection at a time.
Against MS SQL 7/2000 the Transaction Action will row-lock. Robert Shubert Tronics 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
