I just read a message from Arnon, about RI code errors. I remember having problems with the RI Cascade Update/Delete in the VFP 3.0 / 3.0b.
The problem is when you have two or more tables beginning with the same characters. i.e. table1abc, table1, table1xyz. The cascade process fails when searching the tablename in a string, with the ATC() function.
What I did is a clone function for ATC(), called KATC(), that parses the string, and construct an array with the tablenames, and then searches the array with an exact comparisson.
I replaced all the calls to ATC(), with a call to KATC(), that uses the same sintax. And put the KATC() function at the beginning of the Stored Procedures for the database (where the RI code is located).
You have to change the ATC() calls everytime you generate the RI code, but is an easy task.
I don't know if VFP 5 has the same problem, but I want to help you if you are having problems with the RI code.
For space reasons, I can't put the KATC() function on this message. Is small, but the server refuses my last message.
If you need it, send me an eMail to
mer@globalnet.com