Hi,

we struggle with a strange problem. An application of us is running
with Firebird embedded. It works fine for several days. Then there is
a problem with not unique primary key.

We use a generator for primary keys. Records are inserted in one table
only. The primary key field for the table is only set by reading a
value from the generator.

The customer send us a db file with problems and there, the value of
the generator was 2 or 3 lower than the highest value for primary keys
in the data table.

Since we are absolutely shure, that values for primary keys only come
from reading the generator, this is a case, that should never happen.

So my question is, under which circumstance is it possible, that the
latest value of the generator is not written properly to the database
file. I checked and "Forced write" is on for the database file.

Our environment is Delphi, Dbx driver from Upscene, FB embedded 1.5.

The software is used on a laptop, OS is probably Win2000 or XP.

cu Christian