All:
I'm using VFP 7.0 and creating all my local views in a program using "sequential join" syntax. However, I have one very complex view that is performing 9 joins on FPW 2.6 free tables. The view runs fine and produces the correct result, but whenever I try to MODIFY VIEW, I get the following error:
Index does not match the table. Delete the index file and re-create the index (Error 114)
I have verified that the indexes on the free tables are fine. The problem will even happen if I create a 3 table join, but is fine on simple 2 table joins.
IIRC, the VFP View Designer uses "nested join" syntax to create views. Are there any problems using the VFP View Designer when views are created using "sequential join" syntax? Is the problem because I'm using free tables?
Thanks!
--Paul