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.aspIt'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.