Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Synchronize Databases pref. in FPD25
Message
De
23/05/2002 02:17:19
Wally Noll
Double Aa Builders
Mesa, Arizona, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00658516
Message ID:
00660284
Vues:
9
Bhavbhuti,

It is a programming problem, you're on the right track to solve it.

I'm sure you know this, but let me review briefly some things. When a record is deleted it is not really deleted, it is only marked for deletion, it is not deleted until the PACK command does that in maintenance operation. So, these records that you're feeding into the central computer may not be deleted. If you issue 'SET DELETED OFF', then you can see the 'deleted' records. You can even work with them in your programming. You can RECALL them to undelete them. So, if your users can refrain from doing the maintenance procedure that issues the PACK command until after they export info on the floppy to the main computer, then you've got those records all along, just need to analyze them in code. This might be least expensive means for you.

Another alternative might be to modify on those various source machines that feed data to the big main computer so that every time a user deletes a record that it is first copied into a 2'nd and identical table that simply lists the records deleted. This would be a better solution because it wouldn't risk that the users would get rid of the record by doing that maintenance procedure that has the PACK in it.

Hope this helps.

Wally Noll
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform