Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Further discussion: VFP, XML data and Excel
Message
From
09/01/2007 11:41:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Further discussion: VFP, XML data and Excel
Miscellaneous
Thread ID:
01183825
Message ID:
01183825
Views:
102
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 &#xxx; format. We hard-code each character that we wanted to transform. However, the more complex characters like Й (cyrillic) or Ğ (turkish) doesn't show properly in the Visual FoxPro editor. The formatting code looks like this:

xmlText = strtran(xmlText, 'ç', 'ç') && small c with cedilla
*edited: UT converted the code; the 3rd parameter is "& # 2 3 1 ;" without the spaces.

I cannot type in the two characters listed above in the second parameter of the strtran() function inside the Visual FoxPro editor. I've tried setting: _screen.FontCharSet = 162 for Turkish and 204 for Russian and used the Windows On-Screen keyboard to type it in but the literal text Й (cyrillic) or Ğ (turkish) does not display properly.


Or so I thought. While this works without problem when run from the VFP IDE, I get the same error when running it from an executable. The program actually does more than create the XML. It also opens up Excel using a template and import in the XML data. The merging of the XML data is where the problem is. Where before, it had to do with the actual data, now its when I run the program from an executable.
ramil
~~ learning to stand still
Next
Reply
Map
View

Click here to load this message in the networking platform