Hi, You would think that after all this time of people needing to get the unique auto generated id, the database creators would have said, ah-hah, this is something that would be useful.
The way I do it is, kinda convoluted but works without fail I insert the <@USERREFERENCE> value in a field and table that has the auto-increment. There is a trigger on the table that reads the ID and gets the ReferenceArg and places them into another table where the app goes and gets it. What would really be cool is to do an insert and have the ID returned, naah! Makes to much sense and beside there is all these workarounds that people have written over the years and we don't want to upset their ingenuity Ok, got that off my chest, carry on ;-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Robert Sfeir Sent: Tuesday, August 27, 2002 4:37 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Key of Record Just Written -----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
