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.