Usually when a next recordnumber is generated in VFP for whatever table, the record containing the next number or even better, the whole table, is locked to prevent to 2 users to simultanously update the next nr. It's essential that the lock is placed before the update is done.

How can this be done with client/server ?
I don't want the autonumbering feature of the database server because I'm not creating a primary key (as a matter of fact, I do let create the PK by the de DBserver) but for example an invoice number that restarts at 1 every year, unless SQL allows to reset this numbering programmatically ...