Sorry Sergey,

I had to email you. My problem table has many fields (170)



>>Thanks Sergey,
>>
>>We are dealing with a problem and blank fields. The whole record is sent from VFP into the XML structure, but OPENXML is returning errors regarding blank fields: Unexpected NULL value returned for the column : ProviderName=OPENXML, etc.
>>This is because we are opening the XML structure this way:
>>SELECT * From OPENXML(@idocIN, @xpathIN) with MyTable' and MyTable has Null restrictions.
>>It seems that blank fields don't "pass" to SQL.
>>
>>How can we force the blank fields to be passed in the XML data? By using different flags we don't get success.
>>
>
>Can you post the XML document with a couple of records and @xpathIN that demonstrates the problem?