Information générale
Catégorie:
Produits tierce partie
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement