Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you modify a table in a client's machine?
Message
De
28/01/2002 06:38:41
Walter Meester
HoogkarspelPays-Bas
 
 
À
27/01/2002 08:58:50
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
Divers
Thread ID:
00611234
Message ID:
00611426
Vues:
27
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,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform