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!

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

Recent content by mJindrova

  1. mJindrova

    Creating an xml with a .prg (having issues)

    wrong: =FWRITE(gnErrFile, '&red'+chr(13)+chr(10)) right: =FWRITE(gnErrFile, m.red+chr(13)+chr(10))
  2. mJindrova

    Creating an xml with a .prg (having issues)

    Code contains many bugs... XML is Case Sensitive Missing start/end elements Missing prefixes
  3. mJindrova

    Creating an xml with a .prg (having issues)

    from red='<cec:UBLEtension>' to red='<cec:UBLExtension>' from red='<cbc:Name>Klasa opasnosti</cbc:Value>' to red='<cbc:Name>Klasa opasnosti</cbc:Name>' from red='<cbc:ID>urn:fdc:peppol.eu.logistics:bih:despatch_advice_only:1</cbc:ProfileID>' to...
  4. mJindrova

    Strange behavior with SET("Classlib")

    Cryptor use fll (4.0) or DLL COM (5.0).
  5. mJindrova

    How "Print Area" setting in the Report Designer affects margins, particularly the right and bottom margins?

    Chriss, I update your first sentence: Mode "Printable Page" means VFP regards printable area defined in printer driver - paper size (width, length, orientation) and page margins (left, top, right, bottom). Mode "Whole page" is good for e-documents printed within virtual printer and will not be...
  6. mJindrova

    FoxyPreviewer Variable _REPORTOUTPUT Not Found

    Variable _REPORTOUTPUT is a system variable and exist in VFP 9/A. The error message can be confusing.
  7. mJindrova

    SQL Command to Show Monthly Sales Including Months with Zero Sales

    As I told... I have not a crystal ball Yes, IFNULL() for MySQL/MariaDB is right function. Ad Moth table - check if your MySQL/MariaDB version knows Recursive CTE.
  8. mJindrova

    SQL Command to Show Monthly Sales Including Months with Zero Sales

    Because I have not a crystal ball and I do not know your table's structure then sql command can be: SELECT Customer.Code, Customer.Name, Month.Name S MonthName, NVL(SUM(Entry.Amount), 0) AS Amount; FROM Customer INNER JOIN Month ON 0=0; && month is cursor with 12 records (for each month)...
  9. mJindrova

    VFP 调用.NET COM 内存泄漏

    VFP (3-9) has not many functions for releasing unused memory SYS(1104) - free data cache for data area API SetProcessWorkingSetSize(...) IN kernel32 - free unused memeory
  10. mJindrova

    Report format allignment

    see to help: https://www.vfphelp.com/help/_5wn12pzo3.htm
  11. mJindrova

    Report format allignment

    Hi, You can use smaller font (6) for text field NAR1 - NAR6 or sets trim mode to "Trim to nearest character"
  12. mJindrova

    Report layout differs when running

    It's not bug of VFP, but behavior at using GDI+ for rendering text with Gdiplus::StringFormat::GenericDefault . https://stackoverflow.com/questions/118686/measurestring-pads-the-text-on-the-left-and-the-right https://theartofdev.com/2014/04/21/text-rendering-methods-comparison-or-gdi-vs-gdi-revised/
  13. mJindrova

    Opening and reading from a binary file larger than 2GB

    md5.fll and vfpencryption71.fll has functions for calculating file's hash. md5.fll use "modern" API for file access. vfpencryption71.fll use "old" 16 bit API for file access.
  14. mJindrova

    Opening and reading from a binary file larger than 2GB

    1) use ADODB.Stream - https://www.tek-tips.com/threads/open-file-as-unicode-utf-16-and-save-as-utf-8.1818112/ 2) use API - https://github.com/VFPX/Win32API/blob/master/samples/sample_346.md DECLARE LONG CreateFile IN kernel32.dll STRING @, INTEGER, INTEGER, INTEGER, INTEGER, INTEGER, LONG...
  15. mJindrova

    Polish characters in VFP,

    How to change the display language for non-Unicode programs The window: https://activenetwork.my.salesforce-sites.com/hytekswimming/articles/en_US/Article/Setting-Language-for-Non-Unicode-Programs --- Do not check UTF-8

Part and Inventory Search

Back
Top