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
