Getting autoincrement key from newly inserted row

[telbourn7]

I have a table with an autoincrement PK field. After I have inserted a new record, what's the optimum way to retrieve the new PK value ? Do I have to run a select query with the data I have just inserted ?

Thanks

[carlgundel]

Jan 6, 2009 2:55:02 GMT -5 telbourn7 said:

I have a table with an autoincrement PK field. After I have inserted a new record, what's the optimum way to retrieve the new PK value ? Do I have to run a select query with the data I have just inserted ?

I think the answer to that question would have to be yes.

-Carl

[meerkat]

Last I looked they do not have a command similar to the mysql command: "LastID = mysql_insert_id()" to get the last auto increment.

So you must get it..

HTH