Hi Teo,

You should set your table null column to allow accept null value for that field.


>I use C# & VFP OLDBD Provider.
>
>My table have 4 field. When I insert a record to the table and only fill 2 field eg
>
>dataAdaptar.insertCommand.commandText = "insert into tableA (flda,fldb) values ('a','b')"
>
>C# prompt me error that fldC cannot accept null value. How to set C# insert empty value to the field did not specify in the insert command.
>
>
>Thanks.