The next generated sequence in a dbf file for an auto_increment does not always get a new value, it is possible to generate duplicate values.
When I run insert code with Prepared statement caching on (ps is not closed), in both our system (Servoy) and another application, the value inserted in the other app is not seen in Servoy.
For example, in Servoy, I create records (id=1, id=2).
Then create a new record using another app (foxpro),: id=3
After this, the next record in Servoy also gets value id=3, but only with PreparedStatement caching on.
When it is turned off (PSes are closed immediately), we do see the new records and generate new value id=4.
Can you have a look at this?
Our table was created as:
create table tst (id integer not null auto_increment, val integer default null, primary key (id))
Servoy insert sql:
insert into tst (val) values (?)