I have a separate table in my system containing 5 variables. Invoice number, cash order number, packing slip number etc.

This number is retrieved via the set field function, and the new incremented number is set (back) via set field; invoice number = invoice number + 1 etc etc.

However, I've noticed now that for some reason, these 5 variables has recently been reset back a day, ie, i've suddenly ran into duplicate invoice numbers.

I've found no fault in my code, and it works perfectly when trying it over and over again. Can some client accidently set these variables back? Lets say you don't use a client for a couple of hours, then suddenly something happens and the variables are reverted?

Ive made over a 100 invoices with this setup, and I only have 10-12 duplicates, mosty dual duplicates, one or two triples.

any suggestion?

Edited January 17, 200818 yr by Guest

When you say variables, do you mean fields set to global storage?

Is this system hosted or single user?

Finally, you should rely on FM's builtin auto-enter serial numbers for unique key ids in each table, rather than generating them yourself.