Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mibosoft

    When does Cursortoxml() include the dbc() name in the XML output?

    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...
  2. mibosoft

    When does Cursortoxml() include the dbc() name in the XML output?

    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
  3. mibosoft

    When does Cursortoxml() include the dbc() name in the XML output?

    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...
  4. mibosoft

    Problem with Eastern European languages in reports

    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!
  5. mibosoft

    Problem with Eastern European languages in reports

    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?
  6. mibosoft

    Problem with Eastern European languages in reports

    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...
  7. mibosoft

    Problem with Eastern European languages in reports

    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...
  8. mibosoft

    Problem with Eastern European languages in reports

    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)...
  9. mibosoft

    Problem with Eastern European languages in reports

    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.
  10. mibosoft

    Problem with Eastern European languages in reports

    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...
  11. mibosoft

    Problem with Eastern European languages in reports

    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!
  12. mibosoft

    Problem with Eastern European languages in reports

    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...
  13. mibosoft

    Problem with Eastern European languages in reports

    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...
  14. mibosoft

    Problem with Eastern European languages in reports

    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...
  15. mibosoft

    Problem with Eastern European languages in reports

    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...
  16. mibosoft

    Winsock &quot;not enough memory to complete this operation&quot; error

    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...
  17. mibosoft

    Winsock &quot;not enough memory to complete this operation&quot; error

    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...
  18. mibosoft

    Winsock sendata solutions

    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...
  19. mibosoft

    Winsock senddata problems

    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
  20. mibosoft

    Winsock sendata solutions

    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

Part and Inventory Search

Back
Top