Hi,
I am trying to insert a person info into the access table and to return it's new ID (that is autonumber of course) using SELECT @@identity statement. I'm using OleDb command with two statements in batch (Visual Studio 2005), but I get an exception. Ok, I understand it is not possible to have two statements in batch in Access, but how can I get ID of newly inserted item ??
thx,
Dzovan
I am trying to insert a person info into the access table and to return it's new ID (that is autonumber of course) using SELECT @@identity statement. I'm using OleDb command with two statements in batch (Visual Studio 2005), but I get an exception. Ok, I understand it is not possible to have two statements in batch in Access, but how can I get ID of newly inserted item ??
thx,
Dzovan