Getting @@Identity from an Access table

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

My code below always returns 0 for the Identity. Any idea why. The
database is in Access 2k.

int ID=0;
OleDbConnection conn=new OleDbConnection();
OleDbCommand aCommand=new OleDbCommand();
conn.ConnectionString =ConnectionString;
conn.Open();

aCommand=conn.CreateCommand();
aCommand.CommandText =strSQL;
aCommand.ExecuteNonQuery();

strSQL = "SELECT @@IDENTITY AS ID";
aCommand.CommandText = strSQL;
ID=(int)aCommand.ExecuteScalar();
conn.Close();
return (ID);
 
On 3 Dec 2003 16:42:29 -0800, (e-mail address removed) (mike) wrote:

¤ My code below always returns 0 for the Identity. Any idea why. The
¤ database is in Access 2k.
¤
¤ int ID=0;
¤ OleDbConnection conn=new OleDbConnection();
¤ OleDbCommand aCommand=new OleDbCommand();
¤ conn.ConnectionString =ConnectionString;
¤ conn.Open();
¤
¤ aCommand=conn.CreateCommand();
¤ aCommand.CommandText =strSQL;
¤ aCommand.ExecuteNonQuery();
¤
¤ strSQL = "SELECT @@IDENTITY AS ID";
¤ aCommand.CommandText = strSQL;
¤ ID=(int)aCommand.ExecuteScalar();
¤ conn.Close();
¤ return (ID);

Don't believe you need the alias. Try using:

"SELECT @@IDENTITY"

Also, I'm assuming your strSQL value is an INSERT statement?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top