Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refresh Local copy of server Lookup Table
Message
De
15/06/2001 09:39:57
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
15/06/2001 00:35:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00519204
Message ID:
00519914
Vues:
15
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform