I am using the following code to retrieve data into VFP from SQL Server 7.0:
---------------------------------------------------------
gnConnHandle = SQLCONNECT('MySQLServer','sa','password')
lcQuery = "SELECT Name ;
FROM MyTable ;
WHERE

= SQLEXEC(gnConnHandle, lcQuery, "query1")
---------------------------------------------------------
The result is a CURSOR called query1. If I use ADO, I get a recordset, which I then need to convert to a cursor. The only way would be to parse the whole recordset and append to a temporary table. As the results that are being returned can be several thousand records long, is there a faster way to return a cursor directly? My ultimate goal is to export the data to a text file.

Thank you,

Aristotle