Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select outputs
Message
From
24/10/2008 14:54:55
 
 
To
24/10/2008 13:35:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01356977
Message ID:
01357017
Views:
19
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform