Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Conflict Resolution Question
Message
 
À
13/12/2004 18:01:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00968688
Message ID:
00969007
Vues:
8
Hi Gary,

> how I can harness the automatic conflict resolution that VFP offers with remote views.

What VFP does is to write the UPDATE statement so that conflicts are detected. If you set VFP to include modified fields, the UPDATE statement looks like this:

UPDATE SET field=newValue WHERE field=oldValue AND pkField=pkValue

If the command affects zero rows, someone else has modified the record. Next, you could retrieve the current record and compare each field.
--
Christof
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform