Has anyone seen this?
In my app i need a unique number, for example an invoice number.
I have an AutoNumber file (filename: BAC5103), with field FNR:NR (decimal 7.0) holding these unique numbers.
In my program i use Access:File.Insert to get the next number.
This has been working for years in TPS files, never had a problem.
In MSSQL i had to add some code to get the number in the buffer, which i added in the DCT triggers After Insert.
This is working okay!
Now i had already some users that told me the number add’s up 1000, for instance it goes from 200406 to 201406.
When it goes wrong it mostly adds 1000, but that’s not always.
It happens rarely but has anybody seen this behavior, or what could be the problem?