[PHP-DB] Need help getting record number off insert

2002-09-11 Thread Anthony
I'm doing an insert and need to get the record number that is generated when the record in created. I'm accessing the database through ODBC. It's a DataFlex database and the driver i'm using is by Connex. I know that you can somehow insert a SQL statment inside an other statement. I was

Re: [PHP-DB] Need help getting record number off insert

2002-09-11 Thread Miles Thompson
Check the DataFlex docs and see if it has a function that returns this information, or if the ODBC driver has such a function. Record numbers are dangerously useless in most database operations - they get re-used and changed when records are deleted or repair/compress functions are executed.