Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REINDEX or CREATE INDEX??
Message
 
To
23/06/2001 16:33:14
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00522798
Message ID:
00522822
Views:
12
>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!"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform