Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mirror tables
Message
De
18/05/2007 18:46:35
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01226963
Message ID:
01226979
Vues:
25
>>Is is possible to mirror tables in VFP ?
>>
>>I mean, to create an exact copy of the table and uptade, all the time ?
>
>You can write Insert, UPDATE, Delete triggers to do it. I believe there is an article in UT Magazine by Hilmar Zonneveld showing this http://www.utmag.com/ViewPageArticle.aspx?Session=7A39664C377966557263673D20683236326E43686B41656C49703477616A61314349673D3D

The article is about an audit trail; the basic ideas can easily be adapted for replication. At least, it shows how to use the triggers. But I think an audit trail might be more useful - in which case, the code from the article must also be adapted, to make the result "machine-readable".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform