Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Further discussion: VFP, XML data and Excel
Message
De
09/01/2007 11:41:15
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Further discussion: VFP, XML data and Excel
Divers
Thread ID:
01183825
Message ID:
01183825
Vues:
105
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform