Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
REINDEX or CREATE INDEX??
Message
 
À
23/06/2001 16:33:14
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00522798
Message ID:
00522822
Vues:
13
>Hi,
>
>This method is what I do with my applications - one table with all params of talbles and dbc ( fields, indexes, procedures, relations, views, etc) and a general form wich take information and with macrosubstitution recreate indexes, relation, trigers. Best thing is if you make change in structures of table in development, then run a take_program that fils the info table and distribute only the info table at locations where are app instaled and run update_program.
>
>The idea is taken from gendbc.prg of VFP

ok, so i'll drop all tags and recreate all indexes with the help of a table containing all inforation abouts dbcs and tables. But what about the RI code? I'm using the RI code generated by VFP. Do I need to recreate RI code after a complete recreation of the indexes or I can eep using the old one (figuring that i won't change the relations in the DBCs)?

Thanks one more time for your help,

Alonso.
Like Frank said: "I did it... MY WAY!"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform