Robert, It will work but beware there is one version of app server FTS fix that will lock up the whole DB if you use the transaction method.
Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: Robert Shubert <[EMAIL PROTECTED]> > Organization: Tronics Web Services > Reply-To: [EMAIL PROTECTED] > Date: Tue, 27 Aug 2002 21:10:14 -0400 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Key of Record Just Written > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
