Getting ID

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________

Hi

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 .

 

[Miha Markic]

In addition to Bill: this works only with jet oledb provider 4 or higher...