How to save queries on disk.I use the TO clause(example:SELECT * FROM vendors TO w.qpr).Everything works,but when I run the query with DO i receive the following error: http://s52.radikal.ru/i138/1201/2f/15765ffe2346.png And what should I change in order to obtain the query like in query designer,I mean that the query should appear in browse window,but using the command mode. Thank you in advance.
The TO clause is for storing the results of the query, not the query itself. (And, TO is a VFP extension; INTO is preferred.)
If you want to save the query, open up a PRG file (MODIFY COMMAND) and write the query there, then save it.
If you simply omit the TO or INTO clause, the query results will appear in a BROWSE window. Alternatively, use INTO CURSOR and give a cursor name, then issue BROWSE to browse the cursor.
Tamar
