Search results for query: *

Hi Olaf, You are absolutely right. It's the alias name that goes into the XML and if ALIAS is not used, you get the file name. I got confused and forgot that all tables in my database start with the database name :-) All this was discovered when I built a separate executable to do all XML...

Thank you for the hint atlopes! It showed to be due to that if I open a table like this without an alias name, the database name is prepended in the xml: sele A use tablename With this, the alias name without database name is used: sele A use tablename alias TABLEALIAS

I use cursortoxml() in two different applications like this to produce .xml files: select A set fields to field1,field2 cursortoxml(0,"L_XML",1,32) strtofile(strconv(L_XML,9),"outfile.xml") set fields off In application 1, the table names are prepended with the database name like this in the...

I think I will manage now by using a call to HTMLNumEntityToANSI() for (selected) strings in reports. The rest of the application is web based and here it works fine with strings with HTML entities. Thank you both Olaf and atlopes for great help!

Thank you Atlopes. It works when I check "use font script" for a specific field in a report. Do I have to go through every report and every field or is there a any way to set this globally/default for all of my reports and forms?

I should also mention that the language table is only for the strings that are part of the application/system. Users are also entering texts, for example team and player names. This means that Swedish, English, Finnish, Norwegian and Czech users are entering strings into the very same database...

Thank you Olaf for all input on this. Now I'm leaning against keeping my strings as ANSI anyway and store the CZE strings with HTML entities included. I thought of using the HTMLNumEntityToANSI() function above written by atlopes for reports (non-web environment). alopes, could you explain...

I have a languages table with one column per language (swe,eng,fin,nor and cze). I just did this test: 1) I transformed all these strings for all languages to UTF8 with with strconv(<lang>,9). 2) I changed my server to to put UTF8 in the HTTP header (Content-Type: text/html; charset=utf-8). 3)...

So I need to store all of my current strings as strconv(ANSI-STRING,9) in the table to be UTF8 and use STRCONV(TABLE-STRING,11) in reports etc. A problem is that lower()/upper() does not work on a UTF8 string which I sometimes do today in web layouts. It is not shown correctly in the browser.

I have written the server myself using winsock directly and I can change the header to UTF8 and if I do that, texts stored in tables containing the Swedish letters åäö will not be shown correctly. I'm a bit confused here. What do I need to do to use UTF8 all the way from storing texts in...

This is awesome! Then I can store the strings including HTML entities and use this function to return strings used in my reports. Thanks' a lot!

I have full control over the web page and when looking in Chrome, the code page is interpreted as 1252 even though I say UTF8 in the http header: Changing to storing strings as UTF8 is to risky as I have about 1500 strings and probably do string matching here and there. I'm thinking of storing...

I use winsock and take care of the POST buffer and store directly to a vfp table. Here you see how the text začátečníkům looks like in the debugger as an example: How can I treat the texts as UTF8 all the way like you suggest? The text above is stored as "za&#269;áte&#269;ník&#367;m" as it is...

Aha, I didn't realize that the data stored in the tables contains html formatters. Probably due to that the data is htmlencoded when it is sent via POST from the browser. I guess I need to make sure that the original text is stored. I will try the 1250 codepage. The languages I need to support...

Hi, I have a VFP9 web application where I want to add support for the Czech language. It all works fine except for the reports. If Czech words are entered via the web interface, they are stored in the table like this: When I list these words again in the web browser, it looks perfectly fine...

Thank you for your answers. Good hints! However, I might have solved the problem today after several hours of troubleshooting. I use "textmerge to memvar" to prepare the HTML output buffer and the data is picked from memo fields. Dynamic data is brought in via <<command>> and sometimes this...

Hi, I would be grateful if someone could give me a hint on the following problem: Since several years, I'm running a web application based on a Winsock server written by Markus Voellmy: http://fox.wikis.com/wc.dll?Wiki~WinSockOCXSample It uses a "pseudo multi threading" by creating a new...

Problem solved, thanks' dilettante! Solution: 1) Send all data in one single sendata() call. Do not split in chunks and do not close the connection in the dataarival event. 2) Add the sendcomplete() event and close the connection here. (Also, it's important to have the procedure error(). If...

Problem solved! 1) Send all data in a single sendata() call (do not split in chunks) 2) Add the sendcomplete() event and close the connection there. Also, it's important to have the procedure error(). If not, broken connections will lead to memory bloat. /Micael

Ok, I've got the same version. Thanks' for your hints. I will perform some heavy debugging and tuning of the server with the next couple of days and hopefully, I'll learn something. /Micael