PHP, ODBC & Access2k - Getting a field value from the last INSERT
| From: | Dan Boitnott | Date: | Thu, 15 Nov 2001 21:33:39 +0000 |
| Subject: | PHP, ODBC & Access2k - Getting a field value from the last INSERT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14376@lists.php.net to get a copy of this message | ||
I have a table that I need to update using "INSERT INTO table (field1,
field2) VALUES (val1, val2)" The table has an AutoNumber field for a Primary
Key called "ID". I need to get the ID that was assigned in the INSERT.
With PostgreSQL you do this with oids but as far as I know Access doesn't
use them. How then can I do this?
Dan Boitnott
dboitnot@yahoo.com