I have a VFP table with say 100 fields
None of the fields have the Null box ticked
if I say in VFP
Insert into MyTable (MyField) Values ("abc")
... works fine and adds in blanks for char fields and zeros for numerics

If in C# Using VFPOLEDB driver) I say:
Insert into MyTable (MyField) Values ("abc")
It gives me an eror message saying null fields not allowed

Any way around this or am I missing something
Dont want to have to change Database Structure (as other apps use it) or insert 100 fields in the XQL statement

Tia
Gerard