Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
General Question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00692578
Message ID:
00692588
Vues:
24
>At what point does FoxPro commit a record to the table.
>
>I have two users on the network hit the following code at the same time and I am getting duplicate ID's; but two different records.
>
>Select TableA
>Append Blank
>Replace ID with RecNO()
>
>Thank you.
>Neetu

I would suggest implementing a primary key system other than recno(). A tried and true method is to keep a key in another table, call a method to retrieve it (locking the record), and increment it so the next person gets the next number.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform