General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only