Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you modify a table in a client's machine?
Message
From
28/01/2002 06:38:41
Walter Meester
HoogkarspelNetherlands
 
 
To
27/01/2002 08:58:50
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611234
Message ID:
00611426
Views:
26
Hi hilmar,

>The tricky part is to copy parent table before child table (avoid "trigger failed"). Also, if you have a lot of data, it helps to compare table structures and skip tables that haven't changed (use COPY FILE instead).

Therefore you might want to take a look at my TaxRiBuilder in the files section. I use it to turn RI off in such particular cases. It also is a lot faster (when using the fast) than the original builder when appending record. In a lot of my products I use the same strategy (Of copying a new empty database and appending new records) and works fine. Only when the database grows too large it might be a slow option.


Regards,
Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform