Never mind! I got it to work by simply re-building my table joins.


>I'm trying to convert an old FoxPro 2.6 app of mine to a VFP 6.0 app. I used FoxFire! way back when, and I am trying to use FoxFire! 6.0 for the new app. I ran the conversion routine provided with FoxFire!, and that went smoothly. Then I went in and changed all the table names for my data items to the new table names in the VFP database (using the DATABASE!TABLENAME format -- necessary because I renamed the tables). I did the same with all the Joins.
>
>When I try to run a request, the SQL statement is most often missing part of the 'FROM' clause. I'll get:
>
>SELECT
>FROM Table1 INNER JOIN Table2
>on TABLE1.JOINKEY = TABLE2.JOINKEY
>on TABLE2.JOINKEY = TABLE3.JOINKEY
>
>But as you can see it leaves out the "INNER JOIN Table3" part of the clause. Does anyone know why this might happen? This is a highly customized setup of FoxFire!, I seem to remember it taking almost 2 months to complete in the beginning. There are 70 requests, and I certainly don't want to have to rebuild them!
>
>Thanks for your help.