>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
i've heard vfp5 has the same problems...