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

Michel,
VFPOLEDB supports "set null off" command. First do an ExecuteNonQuery on the connection (posted full samples with framework1.1 before).
Cetin