Hello, Rick
Well... fortunatelly, it didn't represent a problem for my code - I use MS SQL Server's referential integrity :)
I was demonstrating to a friend how this thing can help (and it did help me a lot in the past). I created two tables with integer autoinc, set the relation one-to-many on two related fields and tried to set the ri to generate the code to cascade delete. And it trashed the dbc (in fact, the dbx - the index). I couldn't repair it, because I wasn't able to reopen the database. Well.. what if the database would contain 200 - 300 tables? I even don't dare to imagine the desaster...
>I don't remember that there were any announced changes in the RI code. Was this code working in an earlier version of VFP? What kind of linking expressions are you using?
>
>Rick
>
>>Hello, everyone
>>
>>Is there a problem with the Referential Integrity builder in VFP8? It trashes my DBC every time. Can anyone confirm or suggest a workaround, please?
>>
>>Thank you
Grigore Dolghin
Class Software.