>When using the OleDB provider to insert a record in a VFP table, is there a way to avoid all those messages where it complains about the fact that, if a field is not part of the INSERT, that it cannot be null?
>
>For now, I have to insert several fields in the INSERT command, just to put a value of 0 for numeric fields. I would like to avoid that.

If table is a part of DBC, you can set 0 as default for those fields.