Ramil,
Thank you for your suggestion.
>Hi Dimitry,
>
>In VFP, set the 'other' fields of the INSERTed table to allow NULL values. I noticed similar 'errors' when using SQLEXEC() as well.
>
>HTH.
>
>>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