Information générale
Titre:
Local view problems
I am trying to create a local view - when I add a fourth table to it (with the appropriate inner join), I get a "column not found error".
The column IS there (honest), what's more, if I run the view, I get the correct output, but the error occurs when I try to view the SQL or save the view. The column referred to changes depending upon the order of the tables.
If I select the SQL and execute it (or create the view using the copied SQL) all is well until I try to modify the resulting view and...bang...no column.
Am I running into a limitation of VFP - i.e. the view designer cannot handle 3+ tables?
RJL
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