Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict nightmare
Message
De
13/02/2001 13:09:25
 
 
À
13/02/2001 12:10:36
Adam Skowronski
Custom Designed Systems
Miami, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00474619
Message ID:
00475376
Vues:
43
>>>>>>>>>>>>>>>>>>>>>
Thanks to both of you for opening my eyes more on buffering. To date, all I have been using was the BufferMode in the form PIMs, and nothing further. Now I have gone back and used the CURSORSETPROP() when adding/editing a record, followed with the TABLEUPDATE(.T.) when saving it.
>>>>>>>>>>>>>>>>>>>>>
As I mentioned to you on another message, be careful with TableUpdate(.T.). I mean, you should ceck the return value to see if you have any posting conflicts that must be resolved. (see Message #474711)


>>>>>>>>>>>>>>>>>>>>>
Ironically, I was getting away with this for over a year while the customer was running on a Novel network. Now, with the NT network, I was getting stung. Similarly, since the change of networks, the means of assigning Unique ID's to records had to be altered. Duplicate numbering sequences were cropping up when multiple users were adding the same type records. Is there something I should be looking out for when dealing with NT?
>>>>>>>>>>>>>>>>>>>>>
The system that works for me on assigning unique IDs, is to set up a counters table that has two fields, TableName and LastID. Whenever you need a new ID yiu call a funtion (like NewID(Alias()) passing the current alias or table name you want the ID for. The function seeks in the counters table. If it finds, increments and gives you the new ID for your table. If not found, adds the new record with the table name setting the counter to 1.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform