How to get an auto increment from a database

[Wiszh]

Hi,
Does anyone know of a simple means to retrive a auto_increment primary key field after the insert takes place (so a subsequent update can be performed)?

Thanx

 

[mbaranski]

Well, most systems just do:

select max(auto_inc_field) as mac from db.table
Disclaimer:
Beware: Studies have shown that research causes cancer in lab rats.

 

[ChrisCarroll]

Hi Wishz,

You would want to find the specific function that the backend database offers to return that value.

For instance on MS SQL Server:

Insert into tablename ......
Select @@IDENTITY

will return to you the value that you're after. The value returned is guaranteed to be correct for your connection, even if other people are simultaneously inserting.