Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select outputs
Message
 
À
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:
01357019
Vues:
26
>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform