General information
Category:
Third party products
Title:
FoxFire 2.x to 6.0 conversion problems
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only