Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select outputs
Message
 
To
24/10/2008 14:54:55
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:
01357019
Views:
24
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform