copy a programs results to a text file

[PremiumL]

I have a program that runs a state count for a database called mail.dbf. This is the program:

SELECT STATE, COUNT(STATE) AS HOWMANY;
FROM MAIL.DBF;
GROUP BY STATE;
ORDER BY STATE;

How can I copy the results to a text file?

Thanks for your help,

Jarrett

 

[Stella740pl]

You can direct your query results right into ASCII text file by including TO FILE clause.

According to VFP Help for SELECT-SQL,

...
TO FILE FileName

If you include a TO clause but not an INTO clause, you can direct query results to an ASCII text file named FileName, to the printer, or to the main Visual FoxPro window.
...

Or, if you wish, you can select your results INTO TABLE (INTO DBF) or INTO CURSOR, for further use in your program, and then use COPY TO command to send the results into delimited or fixed-width file.

There are other options available for this task as well.