Getting ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

Im working with OleDB and Access db. I was wondering it it was possible to retrieve a ID, with some OleDB object, from an insert sql statement

regards
Palli
 
The INSERT statement does not return anything except a number of rows
affected. To fetch the new ID, you'll have to execute another SELECT to
fetch @@IDENTITY (and your OleDB object.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Páll said:
Hi

Im working with OleDB and Access db. I was wondering it it was possible
Click to expand...
to retrieve a ID, with some OleDB object, from an insert sql statement .
 
Back
Top