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.
ramil
~~ learning to stand still