Information générale
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement