>May I email the DATA to you? It is very awkward to deliver the schema and data by way of th UT. I can deliver the schema in this format but I would ha a difficult time with the data.
>
Sure, you may send it.
However, it is enough to give data for just one record that causes the problem and you can do it in code.
For example:
CREATE CURSOR ....
INSERT INTO ...
oXa = create('xmladapter')
.......
Thanks,
Aleksey.
>>Glenn,
>>
>>Can you provide the table schema and sample data that causes the failure?
>>
>>Thanks,
>>Aleksey.
>>
>>>Thanks for the reply,
>>>
>>>Actually the VFP8 xmlAdapter creates the XML. Here is a sample of the code:
>>>
>>>
>>>oXa = create('xmladapter')
>>>oXa.ReleaseXML(.T.)
>>>lcOutalias = alias()
>>>lcFilename = Upper(Juststem(Dbf(lcOutAlias)))
>>>oXa.AddTableSchema(lcOutAlias,.T.,Strconv(lcFilename,5))
>>>
>>>
>>>
>>>Thanks
>>>
>>>Glenn
>>>
>>>>>I am trying to do a set of file uploads to my web application and am using the VFP XMLAdapter to convert a set or cursors to XML for transport. My problem is that one of the tables which I am transporting has a Character Binary field like so:
>>>>>
>>>>>- <xsd:element name="salehstrnk">
>>>>>- <xsd:simpleType>
>>>>>- <xsd:restriction base="xsd:string">
>>>>> <xsd:maxLength value="1" />
>>>>> </xsd:restriction>
>>>>> </xsd:simpleType>
>>>>> </xsd:element>
>>>>>
>>>>>When converting back to cursors on the Web side the Parser pukes with :
>>>>>
>>>>>Error: XML Parse error: An invalid character was found in text content.
>>>>>
>>>>>Besides eliminating this field, what can I do to avoid this error?
>>>>>
>>>>>Thanks
>>>>>
>>>>>Glenn
>>>>
>>>>Hi Glenn,
>>>>
>>>>Can you post the code that creates XML?
>>>>I would try to map this field into one of binary types when XML document is created.
>>>>
>>>>Thanks,
>>>>Aleksey.