Oledb Jet

[Sal]

Hello All,
In using SQLClient I can add a record in a table and retrieve the Autonumber
Primary Key field of the record added in a single parameter query by
declaring the parameter as an Output parameter.

How can I retrieve the autonumber primary key added using System.Data.Oledb
when the provider is Jet?

Any help would be greatly appreciated.

Sal Sarhangi

 

[Miha Markic]

Hi Sal,

For Jet >= 4.0 you can retrieve it by SELECT @@IDENTITY

 

[Val Mazur]

Hi Sal,

Check next example

http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet

 

[Sal]

Val and Miha,
Thank you for your help.

Sal Sarhangi

 

[mike]

Is the the way described in the article i.e using "SELECT @@IDENTITY" valid
also with Access 97??

rgds,

mike

 

[Miha Markic]

Hi mike,

I don't think so. The Jet 4 is required.