Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote office location - update data to head office
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01401376
Message ID:
01401387
Vues:
72
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform