Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to regenerate database referential integrity.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00095009
Message ID:
00095137
Views:
20
>After changing the RI Update from Ignore to cascade. The program shows
>
>"file __ri_update_prg dosn't exist."
>
>Checking the dbc I noticed that procedure __ri_update_prg isn't in the code field.
>
>Is there a way to tell VFP to regenerate all the ri codes?

I had the same problem when I added referential integrity and then removed it. VFP left the ri_update_prg code in the triggers and did not clea itslef up even after I told it to regenerate the RI code. In my humble opinion Microsoft has a few bugs in the RI area of VFP, I had to do extra cleanup that VFP should have done automatically, but the response I received from this forum is that it is a feature not a bug and I just did not understand what RI did inside a DBC. I know this wont help you, but understand that others have had trouble with RI when using cascade or restrict versus ignore...
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform