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
