Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't find column error on outer join
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00515388
Message ID:
00515395
Views:
16
Well.. If you read in help about SELECT - SQL you will see following about FROM:

If no table is open, Visual FoxPro displays the Open dialog box so you can specify the file location. Once open, the table remains open once the query is complete.

So it is like saying that the table has to be opened before it will be able to run then query. That VFP doesn't automatic use the Open dialog for joins is interesting. But I would say it is always a good idea to open the tables first, so you do not confuse the users of your program (or even yourself 6 months from now).

HTH,

- Erik Niese-Petersen

Crazy Dane in USA.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform