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

Send :
Set null off
before insertion.

OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = "set null off";
cmd.ExecuteNonQuery();

Cetin