Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Must tables be used before call a SQL statement?
Message
From
04/06/2007 14:51:41
 
 
To
04/06/2007 14:42:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01230337
Message ID:
01230343
Views:
26
>I have always thought that the (free) tables used in a SQL Select statement must already be opened before the SQL is executed.
>
>The other day, I entered a Select.. statement from the command window when no tables were opened, and the darned thing worked!!
>
>So which way is it? If the free tables are in the search path, is it ok to call a SQL select in the load() of a form without first "use"ing the tables?

Yes.
Isn't Foxpro beautiful?
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville

No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)
Previous
Reply
Map
View

Click here to load this message in the networking platform