Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Run Referential Integrity Builder in Code
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Run Referential Integrity Builder in Code
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00978813
Message ID:
00978813
Vues:
84
I have been creating a new database on the fly from several exsting tables for a major conversion project. During this conversion I add tables, set up indexes, set up keys, run Alter Database commands, etc. At the end of the conversion I have to modify the database in order for my referential integrity rules to be implemented. FoxPro Help states:

Caution When you make changes to the design of a database, such as modifying database tables or altering indexes used in a persistent relationship, you should rerun the RI Builder before you use the database. Rerunning the RI Builder revises the stored procedure code and table triggers used to enforce referential integrity so that they reflect the new design. If you don't rerun the RI Builder, you might have unexpected results, because the stored procedures and triggers are not rewritten to reflect your changes.

So my question is how can I automate the running of the RI Builder or how can I do this in code?

TIA
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform