>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
We were beat exactly by the same problem yesterday, so I am very interested in finding solution to this problem.
BTW, I was thinking about trying to implement Walter's Meester (?) Tax RI Builder. It claims to create a more compact code and we currently have lots of SP.
If it's not broken, fix it until it is.
My Blog