Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and SQL SELECT statement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00521468
Message ID:
00521489
Vues:
13
Can you use a SELECT statement with [INTO] for a view like they are used for in a table?

Assuming you mean, simply, can you
SELECT * ;
   FROM View1 ;
   WHERE < some condition > ;
   INTO CURSOR curTemp
The answer is "yes", although many will ask, why not just build another view? But, if you want to you can certainly do it. I do it when I need the intermediate result set for something else and I'm afraid that the filter might change. That way I only have to change the filter condition in one location and it cascades to the other results.
-cjh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform