Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Probably an odd question
Message
 
To
23/01/2003 10:32:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00744557
Message ID:
00744982
Views:
12
I think if the original question was concerning a query from one table, then Hilmar was correct. If you SELECT from one table, then try to query the results set, you will get the message "Must use SELECT...INTO TABLE". If you are joining two tables this doesn't happen. VFP does, behind the scenes, a USE...AGAIN on the one table scenario. That's why the error. But with a join of two or more tables, that doesn't happen.

However, I, too, have gotten into the habit of always using NOFILTER. :)

Dana

>Hello Hilmar,
>
>I'm sure you are aware that this is not always true...I run ad-hoc queries and forget to use NOFILTER all the time, and I usually have no problems running queries against the results.
>
>But for production code, NOFILTER is certainly the safer route.
>
>> NOFILTER is required if the result of a query is used for further queries.
>>
Where's the damned Any Key?...too late
Previous
Reply
Map
View

Click here to load this message in the networking platform