Home CSS Editor Reports Office Code Gallery Download Order Contacts

New in 4.8

  • Delphi 12 support.
  • New htide unit - get installed Delphi versions, Library paths, PAS and DCU parsing, etc.
  • New demo (/Sample Projects/graph) - Unit dependency viewer.
  • Cairo canvas support on Linux and Windows for Delphi and Lazarus. Canvas supports precise text rendering so PDF and other documents converted by HTML Office library now can be properly displayed on Linux.
  • PDF export on Linux via Cairo.
  • Reports library now supports Lazarus
  • Big upgrade of SQL framework: perform SQL queries on CSV and text files, JSON, XML, Excel, Outlook, SQL scripts and other sources.

    What it can do:
    • Convert to/from CSV, JSON, XML, HTML, Excel, SQL script.
    • Upload files/objects to database
    • Export data from database
    • Check data consistency
    • Display data/objects in DB-aware controls, HtPanel, StringGrid, VirtualTreeview, ControlList
    • Extend database capabilities (f.e. use Pivot in Firebird).
    • Serialize and deserialize objects
    • Reduce calls to REST server by using already loaded data.

    Supported data sources:
    • CSV file
    • JSON file
    • JSON string
    • XML file
    • HTML file
    • Text file with fixed size fields
    • SQL script
    • ZIP archive
    • XLS/XLSX Excel sheet (requires HTML Office Library).
    • Outlook PST/OST file (requires HTML Office Library).
    • TList<T>
    • TObjectList
    • Any class with IEnumerable or GetEnumerator support
    • TDataset
    • array of T
    • SQL Query
    Custom sources can be added by implementing IDMDatasource interface.
    Supported dialects:
    • SQL 92
    • Oracle
    • MS SQL Server
    • Firebird
    • MySQL
    • PostrgesSQL
    • SQLite
    • ElevateDB

    Result can be exported to
    • CSV
    • XML
    • JSON
    • SQL script
    • TDataset
    • TStringList
    • TObjectList
    • SQL table
    • HTML (plain table or using template)
    • Array of variant
    • Binary file
    • or any other format, using custom processing of result data.