How can I get the ID of the last added record?

[angor]

Hello!
I need to know the ID of the last added record into the DB (it is auto_increment).
is there some function, like last_id or smth. like that?
would be thankful.
Andrew

 

[lupins46]

DMax("idfieldname","tablename")

 

[angor]

OK, but what if at one unpleasant moment it won't be the MAX? i think it can be possible . who knows how auto_increment works ?..
Andrew

 

[Remou]

Have you considered LastModified?

!LastName = "Warren"
.Update
' Move current record pointer to the most recently
' changed or added record.
.Bookmark = .LastModified

 

[KenReay]

Hi

See also %Identity% in help, if using SQL to add record

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[angor]

Dear Ken Reay!
I have tried this (i found SELECT @@IDENTITY), BUT it always returns 0. maybe i have to change some property of this auto_increment field? i 've tried to find it out, but didn't manage to.
i do need it very much, and would be thankful to everybody who could help me.

Best regards
Andrew

 

[angor]

I am working on ADO.NET 2003. So I have such kind of a code:


private void Updating()
{
this.OleDbConnection1.Open();
string strsql = "UPDATE table1 SET name = 'Johnson'";
Oledbcommand cmd = new Oledbcommand(strsql,this.Oledbconnection1);
Oledbdatareader rdr1 = cmd.ExecuteReader();
rdr1.Open();
rdr1.Close();

string strsql1 = "SELECT @@IDENTITY";
Oledbcommand cmd1 = new Oledbcommand(strsql1,this.Oledbconnection1);
int last_num = cmd1.ExecuteScalar();

this.Oledbconnection1.Close();

and after that I have
last_num = 0
WHy???
Andrew

 

[KenReay]

Hi

The SQL statement you give in your example is an UPDATE statement not an INSERT statement

I believe @@IDENTITY is only relevant after an INSERT statement

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK