Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
From ADO to a VFP Cursor
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00430844
Message ID:
00430951
Views:
9
>>>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
Map
View

Click here to load this message in the networking platform