Re: AutoInc in mdb

create a tadoquery and in it put .. select * from mytable where 1=2.
That will "initialize" a dummy recordset with no records in it when you open
the set.

when you append a record and fill in values the autoincrement field (gotten
with select *) will be updated to reflect the current value of the record
once it is posted in the db.

You can do this in batchoptimistec locking mode or optimistic locking mode.

The value will be populated from the database after you do "post" or
"updatebatch" .. i always use batch mode.


.