Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table using VFP OleDB
Message
From
08/02/2005 18:52:55
David Mckay
Australian Workplace Software
Sydney, Australia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Title:
Create Table using VFP OleDB
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00984982
Message ID:
00984982
Views:
77
I am trying to create a new table in a foxpro database in c# and was wondering why it doesn't create the physical table, here is the code below which i am using...

*-------------------------------------------------------------
string conn = "Provider=VFPOLEDB.1;Data Source=C:\\Temp\\FoxPro\\test.dbc;Password='';Collating Sequence=MACHINE";

OleDbConnection oleconn = new OleDbConnection(conn);

OleDbCommand olecmd = new OleDbCommand("CREATE TABLE newtable (number CHAR(15))", oleconn);

oleconn.Open();

olecmd.ExecuteNonQuery();

oleconn.Close();
*-------------------------------------------------------------

Could this be an issue with the oledb foxpro driver??

Any help would be appreciated..

Cheers

Dave
Next
Reply
Map
View

Click here to load this message in the networking platform