Bret:

what i did was open the dbc

use main.dbc

remove the RI procedures stored in a memo field code.
and then modified the database and left vfp rebuild the ri codes.

it worked!


>>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...