> [Alan McDonald] Nigel I don't think this is correct. The
> MySQL return of the
> last insert ID is done on a connection by connection basis.
> If you remain
> connected between tne insert and the query for lastinsert
> value, noone else
> can ever get that value.
> Alan
>

Sorry, must have worded it badly.
I meant the idea of using GEN_ID(generatorname,0) in FIREBIRD to get the
last ID used...not MySQL.
In between the time your insert has finished, and the time you fetch the ,0
from the generator, it could have been called 100 times...

Sorry for the confusion...

Nige.