Hi Lutz,

Hint for quick fox AND lazy dog: Do not use the DBC generated RI.
I read you don't use Stonefield and from the thread guess you don't use xCase as well -
Look inside the old Booth / Sawyer foxpro book - it has SQL based RI code easier to follow.
Steve is still around - drop him a line if you don't have the book...

my 0.22€
thomas

>My problem is referential integrity.
>Open a database with foreign keys using OPEN DATA .. EXCL, then MODI DATA. Right click a relationship (the line), select "Edit Relationship integrity".
>
>There are three pages where you can set referential integrity for the relationship. To do this using code is the goal.
>
>You get the actual setting using ADBOBJECT(laArra,'RELATION'), as Tamar suggested, but how to set?
>
>Tip:
>Help on ALTER TABLE ... ADD FOREIGN KEY is wrong anyway. COLLATE is placed wrong. See https://github.com/VFPX/HelpFile/issues/18
>
>I do not use that, but a friend comes up with a corrupted database made by a framework that creates this stuff. I know what to set, but not how, and on IDE it is a no go. To many elements.
>
>Lutz
>
>Update:
>The field in the DBC, RIINFO, has a description as .. used by the Referential Integrity Builder (in 60dbc.frx) but automatically used by VFP.