Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote office location - update data to head office
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01401376
Message ID:
01401387
Views:
71
Add a location field C(1) to indicate which location the record was created in (A or B), and then generate primary keys as GUID's. Now, when you update location B with Location A's data, you just delete for location A in location B's data and then insert location's A's records into Location B's tables.

Sergey Berezniker has the GUID code for you already done:
http://www.berezniker.com/content/pages/visual-foxpro/generate-guid
Brandon Harker
Sebae Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform