RE: [PHP] get insert_id in odbc

Having to query the DB again and/or create my own function is what I wanted to avoid, but looks I'll have to do it. Thanks for the replies... ---> Jonathan -----Original Message----- From: Ernest E Vogelsinger [mailto:ernest@vogelsinger.at] Sent: Wednesday, February 19, 2003 2:45 PM To: jvilla@isdesigndev.com Cc: php-general@lists.php.net Subject: Re: [PHP] get insert_id in odbc At 21:28 19.02.2003, Jonathan Villa spoke out and said: --------------------[snip]-------------------- >Using MySQL, one can use mysql_insert_id to get the value of an >auto_increment column. > >How would I do this using ODBC and Access? --------------------[snip]-------------------- Assuming the ID column is named "ID": insert into TABLE (columns) values (values); select max(id) from TABLE; Caution 1: If your database supports it you MUST enclose both line within a transaction or you might get a wrong result when somebody inserts another row in TABLE before your select max(id) statement executes. Caution 2: On heavily filled tables, select max(id) might have some performance issues. Generally I despise using Access in a multiuser environment. Too slow, too error prone with simultaneous access. And I don't know if transaction support is more than syntactically implemented... Using PostgreSQL, for example, you'd have the ID column declared like this: create table TABLE ( id serial, ... ); This generates a sequence that can be queried without performance penalty: select currval('TABLE_id_seq'); -- >O Ernest E. Vogelsinger (\) ICQ #13394035 ^ http://www.vogelsinger.at/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php