Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Standard Techniques for Distributed Applications
Message
 
To
17/05/2001 13:10:52
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00508412
Message ID:
00509656
Views:
20
I would do everything in batches.

Send your data sets back to the server in XML, then convert to cursor. Scan cursor recieved from client: (1) if no primary key, a new record was added. Add key then do an insert. (2) For deletes, use an extra field that indicates a deleted record. If field is flagged, delete from underlying table (3) If record has primary key and no delete flad, it's an update. Update underlying table. Put all this into a single SCAN ENDSCAN loop.

To reject updates while another person is editing, use a some sort of timestamp to see who got to record first.

Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform