Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conflict Resolution Question
Message
 
To
13/12/2004 18:01:32
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00968688
Message ID:
00969007
Views:
10
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform