🚀 go-pugleaf

When I want to add a record into an mdb database, the auto-number field
"MovieID" is assigned to some higher values, not sequential like 1,2,3...but
121, 137, 258 etc. Is this caused by the ODBC connection? When I enter
records in the program that uses the database, they are strictly sequential
in the index field, except the first after an import via BDE engine. It
seems, the last value is stored in the mdb file and from this value
incrementing starts.

The database contains 34 tables. The table I use has 79 fields. When I
import records, the ID numbers have an increment of 79, starting from some
value like 547 or anything. When the records are added in the original
program directly, the increment is always 1.

I use a TTable, connected to the local database file.
For adding I tried the statements
Table1->AppendRecord(ARRAYOFCONST((( int) 0)));
or
Table1 -> Append();

The value entered in ARRAYOFCONST is always ignored.

After disconnecting the increment is more high (e.g. 547, 1015). When I stay
connected, the increment is always 79 (the number of fields), but 1 would be
correct and sufficient.

Any help would be greatly appreciated.

Kind regards sincerely,
Wolfgang