Thank you also, Chuck!
> -----Original Message----- > From: Chuck Lockwood [mailto:[EMAIL PROTECTED] > Sent: Monday, July 05, 2004 2:43 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Record Key just written > > > I use the following in a Direct DBMS immediately following the insert and > the value is in resultset[1,1]: > > SELECT <@LITERAL VALUE='@@IDENTITY'> AS 'Identity' > > Chuck Lockwood > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > LockData Technologies, Inc. > 309 Main Avenue, Hawley, Pa 18428 > 570-226-7340 ~ Fax: 570-226-7341 > [EMAIL PROTECTED] ~ www.lockdata.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Monday, July 05, 2004 2:25 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Record Key just written > > Search for @@IDENTITY > > I think if you do a directDBMS right after the insert it will give you > the identity field last value > > Ben Johansen - http://www.pcforge.com > Authorized Witango & MDaemon Reseller > Available for Witango Developement > > > -----Original Message----- > From: Tom Ferguson [mailto:[EMAIL PROTECTED] > Sent: Monday, July 05, 2004 11:01 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Record Key just written > > I'm certain this has been discussed before, but I searched the archives > and > couldn't find it. > > Is there a simple way to retrieve the key of the record just written to > a > SQL database? I'm sure there is, but I just can't seem to recall at the > moment. > > Any suggestions would be appreciated. > > Tom Ferguson > Enroll DR, LLC > 710 94th Ave. N. #304 > St. Petersburg, Florida 33701 > > www.enrolldr.com > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
