I use
SELECT MAX(OrderID) FROM tblOrder
which should work ok if no one else has updated the table
Ian
At 22:02 03/04/2001 +0100, you wrote:
On Tue, Apr 03, 2001 at 12:08:03PM +0100, Roland Corbet wrote:
I'm Using DBI::ODBC with MS Access 200.
Can anyone tell me what is the best
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
On Tue, Apr 03, 2001 at 12:08:03PM +0100, Roland Corbet wrote:
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