Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and SQL SELECT statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00521468
Message ID:
00521489
Views:
12
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
Previous
Reply
Map
View

Click here to load this message in the networking platform