Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dumb xmladapter or Dumb me
Message
From
25/06/2003 18:22:23
 
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00803232
Message ID:
00804027
Views:
48
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform