Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting record into VFP from .NET
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
00818676
Message ID:
00818745
Views:
13
This is configurable via the OleDb command line for your connection string.

Something like this works:
this.oConn = new OleDbConnection("Provider=vfpoledb.1;" + 
             @"Data Source=D:\Programs\vfp70\Samples\Data\testdata.dbc;" + 
              "Exclusive=false;Nulls=false");
You can find out more by looking at the VFP Interop document at:

http://www.west-wind.com/articles.asp

It's the oldest one of the bunch...






>When I execute a nonquery command (insert) from .NET to add a record to VFP db, .NET fails unless I specify _all_ fields. Otherwise, I get error "Field MYFIELD does not accept null values".
>This is, of course, different from inserting a record in VFP. Is there an option or some way to do it such that I only list some fields in the INSERT command?
>
>TIA.
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform