Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh Local copy of server Lookup Table
Message
From
15/06/2001 09:39:57
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
15/06/2001 00:35:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00519204
Message ID:
00519914
Views:
14
>But how we find out the data content have been changed rather than added?

Here's a likely scenario:

You could set up two additional fields - a datetime field in the lookup table which would keep the time of last save for each individual record, and the time of the last save for any record, in the same place where you keep the primary key counter. This would require some code in the save method (or in the update trigger, whatever you use). The need to update would be checked by comparing the last save time in the local copy versus the last save time in the PK counter table. If needed, you'd update any records where the record's save time was fresher on the server.

YMMV, though, depending on the size of the table, the frequency of changes in it etc.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform