Automatic numbering skipping numbers

[lorel]

I have a POS application running on Clarion 5.5g that creates invoices. The invoice are to be numbered automatically by the system, about 6 months ago we notice that, at times, it skips numbers. What could be causing this?
Any help will be appreciated.
Thanks
Joe

 

[Auke]

The Clarion AutoIncrement works by first inserting a record on an insert, and than changing the record. This is because in a Multi-User environment multiple users could insert a record. See sample:
User 01 [INSERT]
Clarion looks up last number (say 5) and creates a new blank record with only the increment number filled with 6 and resturns this record to User 01.
User 02 [INSERT]
Get record with number 06.
User 01 [CANCELLED] the update. The record with number 5 gets deleted.
User 02 [SAVE]
Record gets saved with number 06.

 

[lorel]

Thank you Auke. You are correct! I suspected something of the sort but I could not prove it to the client until I observe the client doing just what you describe.
Now I am trying to modify the form so if the client do an insert then tries to cancell whith out entering any info, it will advise the client that the invoice will be set as void. I still working on this.

Again thanks

Joe