Thank you, Rick. I already printed your document (I can't read from the screen) and will study it.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham