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.
Thanks.
>Take a look at
Re: Sending a list from vfp Message #
829213. It should give you a basic idea how to pass XML to SP and process it there.
>
>>Thanks Sergey.
>>
>>I will Try.
>>
>>
>>>T-SQL doesn't allow parameters of a table type but you can pass XML.