>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?
--sb--