Marc,

I'm sure that there are those here at UT who'll shoot me for this, but........
I don't use the RI builder at all anymore. I do use stored procedures, but I write the code. I simply ran into too many problems with it like the one you've run in to. I also found that the DBC would get corrupt far too easily. Yes, I back up daily, even hourly if necessary but I couldn't put up with it anymore and don't use it. My stored procedures are backed up to a prg file called StoredProcedures so if my DBC does go bad, I simply copy it back in. I haven't had much trouble with my DBC since dropping the native RI stuff.

Steve


>Hi all...
>
>Using VFP 5.0a on WinNT 4.0 sp3, I am having a problem with referential integrity of my database not working properly.
>
>My db consists of a parent table (parent) and three child tables (child1, child2, child3). Each parent - child relationship is a one to one relationship using the same candidate index field (myKey). The myKey field in each table is the same type and length (character, 20).
>
>I have referential integrity set up so when a record is deleted in the parent table that any related records in the child tables are deleted also (cascaded). On two of the child tables, this works fine. However, on one of them (child1) (perhaps I should call it 'problemChild1') is doesn't work. The record in child1 which corresponds to parent is not marked for deletion.
>
>BTW, the Referential Integrity Builder dialogue box does show that all three parent-child relationships are set to 'cascade' for 'rules for deleting.'
>
>What could cause this? I've tried reseting all the referential integrity rules to 'ignore', saving it, going back and changing to 'cascade,' but no change. I've tried deleting the index in child1 and recreating it, but also no change.
>
>I've looking in MS Dev Net, but nothing there. I suppose if I have to, I could change my app so that when I delete a parent record, I delete the child record, but I think I'd rather have the dbms handle this.
>
>Thanks in advance,
>Marc Mandel