General information
Forum:
Microsoft SQL Server
>>>I am using the following code to retrieve data into VFP from SQL Server 7.0:
>>>= SQLEXEC(gnConnHandle, lcQuery, "query1")
>>>---------------------------------------------------------
>>>The result is a CURSOR called query1. My ultimate goal is to export the data to a text file.
>>
>>
>>With the cursor created by the SQLEXEC function, you can use the EXPORT command. You don't need to pass through ADO for this.
>
>That is correct. I just wanted to use OLEDB instead of ODBC.
If you've got something that can use an XML file, you can save the recordset as XML with the Save method.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only