I use explicit values, if it empty - "" if it logic - .f. etc... And it requests Primary index key...


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