Return ID # number after insert

jpws6 · #1 (**permalink**) 03-09-04, 10:49

What is the best way to do this? I have a form that a user submits to my oracle database, a trigger assigns the data an ID # and then I want to return the ID # to the user and am not sure how to go about this. I was going to use a recordset with the ID #'s and just display the last number, but quickly found out that will not work since the values are not inserted in order in the database among other reasons.

jpws6 · #2 (**permalink**) 03-10-04, 19:43

Any suggestions?

yoja7 · #3 (**permalink**) 03-11-04, 00:12

hi

try using CURRVAL

or search gogle for oracle and currval

Bullschmidt · #4 (**permalink**) 03-12-04, 01:46

4GuysFromRolla.com : ASP FAQS : Databases, General
How do I get the record number of a just added record, using an Access database table? by Bill Wilkinson - 11/3/2000
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79

ADO FAQ - Q9) How do I get the AutoNumber (or Identity) for a newly inserted record?
http://www.able-consulting.com/ADO_Faq.htm#Q9

INFO: Identity and Auto-Increment Fields in ADO 2.1 and Beyond
http://support.microsoft.com/support.../q233/2/99.ASP

Internet Services

Web Development

Digital Marketing

Consumer Tech