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 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"?
You may find that
select * from tablename where Autonumber_column IS NULL
magically does the right thing (a vague memory that may be wrong).
Tim.