I'm Using DBI::ODBC with MS Access 200.
Can anyone tell me what is the best way of getting hold of the Autonumber
that has just been entered into the database with the previously executed
SQL statement.
Perhaps a "select Max from Tablename"? The site is only going to have
low-usage, so I would think this might be acceptable, as it's very unlikely
that someone could have entered another entry between the insert and select
max statements.
I was just wondering if there was a 'watertight' method that I could adopt
instead of "select max"?
TIA for you time and help.
Cheers,
Roland