Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two way database synching
Message
De
16/07/2017 20:00:08
 
 
À
15/07/2017 18:04:06
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 9 SP2
OS:
Windows 7
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01652594
Message ID:
01652677
Vues:
65
J'aime (1)
>Hi Mike,
>
>Long time!
>
>Also thought about this. Just cannot figure how this work for deleted records? Say my Products have 56 rows, then it is dumped to the branches. Great. Then, a few Products were removed at Head Office - no timestamp will be recorded here. This means the update algo should be "two-sided "- one needs to check the new timestamped records from Head Office - and also - use Branch Products to check against the entire Head Office Products for any missing ones for deletion, right?
>
>Is there a more elegant way? :)

Hey Dennis! Long time indeed :)

Yes, a bit more elegant.
Don't delete any records.
Add an "active" logical field and default to .T.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform