Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Further discussion: VFP, XML data and Excel
Message
From
10/01/2007 11:06:07
 
 
To
09/01/2007 16:01:31
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01183825
Message ID:
01184216
Views:
28
>>>>Hi all,
>>>>
>>>>I posted this problem and found a solution to it by using CONFIG.FPW with the proper CODEPAGE setting in it.
>>>>
>>>>Problem: We have a program that creates an XML file output. As such, international characters have to be transformed to its equivalent in
>>

>>
>>Easy for you to say. ;)
>
>Are you sure you quoted the relevant part of the message? :)
>
>Ah, no, it was my message that got truncated.
>
>It was about the extended character set and cursortoxml() which produces unreadable xml unless the character, varchar and memo fields are marked as NoCpTrans (i.e. as binary). Binary fields are stored as Base64 strings in CDATA blocks, which then presents no problem.
>
>Now that he says they have a program which creates XML - if it writes XML by using some other technique than cursortoxml(), then this may or may not apply.

I use straight STRTRAN() and STRTOFILE() functions to build the XML - which is actually a text file as far as my program is concerned. The resulting XML file can be opened in IE without problem so I think the XML file is valid.
ramil
~~ learning to stand still
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform