Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Probably an odd question
Message
 
À
23/01/2003 10:32:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00744557
Message ID:
00744982
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform