Hi Naomi . Thanks for replying.
I inserted a Commandtext of 'SET NULL OFF' , ran a ExecuteNonQuery and it solved the problem

Many thanks
Gerard


>>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
>
>I think it may depend on SET NULL setting in the database. It is different for VFPOleDB and your VFP environment. If you change that setting in VFP, you'll get the same error as in C#