Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two way database synching
Message
From
16/07/2017 20:00:08
 
 
To
15/07/2017 18:04:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01652594
Message ID:
01652677
Views:
64
Likes (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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform