Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select outputs
Message
De
24/10/2008 15:06:37
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01356977
Message ID:
01357022
Vues:
17
>>>>When working with the OLEDB driver via NET, is it possible to SELECT into a CSV or other text file format? Seems like it only supports DBF.
>>>
>>>No (AFAIK) but you could use Stored procedure to do it.
>>
>>Great idea. Can you tell me how to execute a stored procedure in NET? I have
>>		Dim oConnVFP As New Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("VFPLibrary").ConnectionString)
>>		Dim strCSV As String = "do createcsv"
>>		Dim objCommandCSV As New System.Data.OleDb.OleDbCommand(strCSV, oConnVFP)
>>
>>		oConnVFP.Open()
>>		objCommandCSV.ExecuteNonQuery()
>>		oConnVFP.Close()
>>but its not quite right.
>
>Have no idea :-)
>Maybe
>
>Dim strCSV As String = "createcsv()"
>should work.
>BTW are you use VFP Database or free tables?

Dim strCSV As String = "createcsv()" && doesn't work either. I'm using a DBC.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform