Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Mirror tables
Message
From
18/05/2007 18:46:35
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01226963
Message ID:
01226979
Views:
24
>>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform