Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Mike,
I am going the route you showed - via two one way updating. Am finishing on the POS since it will have to be implemented end August. This "synching" is on the next plate. :)
Thanks! I was leaning initially towards doing MySQL's Master Slave thingy. Your suggestion definitely is way simpler to implement.
Keep in touch sir! :)
>>>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?
>>
>>Yes, a bit more elegant.
>>Don't delete any records.
>>Add an "active" logical field and default to .T.
>
>How did you choose to implement it?
>Were you able to get this working?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement