Hi Team,
Is there a way to determine the next autoinc value before actually posying the new record?
Regards & TIA,
Ian

I should have said programmatically.  Not via SQL.
I can't see anything that looks like edbTable1.LastAutoInc or edbtable1.Nextautoinc.
Ian

Ian


No, and I can't see how there could be. Consider two users (or two threads or whatever). A checks the next autoinc, but whilst this is happening B posts - woops.

The only way to do it is maintain the values yourself.

Roy Lambert

Hi Roy,
Actually I meant the last autoinc value.
I cheated and simply open the table, goto last, read the value, close the table, use the value.
All in 4 lines.
Seems to be working fine.
Fortunately, this isn't a multi-user application.

Regards,
Ian