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
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.