Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select outputs
Message
De
24/10/2008 14:54:55
 
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:
01357017
Vues:
18
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform