Documentation Invantive
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Notes de mise à jour de Invantive Query Tool for Windows, 25.0 à 26.0

Notes de mise à jour - Programme d'installation

Invantive Query Tool for Windows 26.0, de 25.0

Construire Date Description Plate-forme
25.0.233 08-07-2026 last build of release 25.0 Windows; .NET Framework 4.8, .NET 8 or .NET 9 builds
26.0.370 30-10-2026 last build of release 26.0 64-bit Windows 10 version 1809 or later; .NET 10 (self-contained)

The 26.0 line also contains the builds 25.1.x of the preceding beta period (2025-09-01 to 2026-03).

  • 78 améliorations
  • 64 corrections de bogues
  • 8 Éléments à vérifier avant la mise à jour

Avant de procéder à la mise à niveau

Ces modifications nécessitent une vérification :

Les 25 principales modifications

  1. Query Tool is built for .NET 10 on 64-bit Windows; the .NET Framework 4.8, .NET 8 and .NET 9 builds are dropped
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  2. Licence keys are validated by the Invantive License Service
    • Amélioration
    • Licences are validated and renewed through the central Invantive License Service instead of the CryptoLicensing method of release 25.0. The licence window and the status text show the licence number, contract code and origin, and the service decides which platform modules a licence includes. A key of the old format gets a message that explains how to continue. A valid licence stays in force for up to 24 hours when the service cannot be reached.
  3. Saved credentials are stored in a new file that is the same on every system
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  4. Data containers can be defined on Invantive Credentials Server
    • Amélioration
    • Connection details, licence checks and OAuth credentials are retrieved from Invantive Credentials Server instead of a local settings file. The connection list shows the server and database, log-on no longer asks for an alias for these data containers, a retrieval is repeated up to three times after a time-out, and the messages are clearer.
  5. Parts of a PSQL block can run in parallel
    • Amélioration
    • PSQL gets a PARALLEL construct that runs branches and loop iterations side by side. Failures of branches are collected and can be read afterwards. The new package dbms_atomic holds named values that parallel branches share safely.
  6. Scripts can run operating system commands with the new package dbms_os
    • Amélioration
    • The new PSQL package dbms_os runs an operating system command and returns its output and exit code, and calculates a file hash. Output is cut off at a maximum length and environment variables can be given. A command that runs too long is ended together with the programs it started. The feature is available in products that serve one user, such as Query Tool and Data Hub, and is switched off on shared hosts.
  7. A script can query its own execution profile
    • Amélioration
    • Runs of Invantive Script, their statements, started operating system commands and script variables are registered and can be queried with plain SQL through the new data container Script and the data dictionary. Duration, CPU use, rows touched, exit codes and output volume are available. Statement text can be anonymised and variable values masked.
  8. Left join without the word OUTER is no longer turned into an inner join
    • Correction d'un bug
    • A statement written as left join, right join or full join, without the word outer, was executed as an inner join. Rows without a match on the other side were lost without any warning.
  9. Case expression uses the widest data type of all branches
    • Correction d'un bug
    • A case expression took the data type of the first branch with a type. A narrow first branch, such as a whole number, then cut the decimals of a wider branch evaluated later. The widest type of all branches is now used.
  10. Fix comparisons on the result of functions such as left, ltrim, rtrim and nvl
    • Correction d'un bug
    • A comparison on the result of left or a similar function could return no rows, and nvl on a nullable number could answer null instead of the replacement value. The trimming of constants now removes blanks only, as it does for columns.
  11. Resolve whole numbers in SQL as integers instead of decimals
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  12. Take one size value in the QR code functions
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  13. Visma.net: new API generation, Visma Connect log-on, sales orders and time cards
    • Amélioration
    • The Visma.net driver uses the current API specification, signs on through Visma Connect and respects the limit of 15,000 calls per hour by waiting when it is used up. It adds tables for Sales Order V3 and for time cards, including filtering, paging, insert and update. A filter such as not equal on a column with a fixed list of values is turned into requests for the remaining values.
  14. Exact Online incremental tables are no longer reloaded in full without need
    • Correction d'un bug
    • Incremental tables could be reloaded in full when the row count check gave a false alarm, when a rejected earlier version was not rewritten and when old deletions held the starting point back. These causes are repaired. The disk cache setting of the execution no longer switches off the incremental cache.
  15. Exact Online incremental tables are written more safely
    • Amélioration
    • New chunks of an incremental table are written under a new generation, so the previous copy stays complete until the new one is listed and an interrupted load does not damage it. A new setting limits the age of deleted rows and raises message itgeneor878. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
  16. XML from outside is no longer allowed to load external entities
    • Correction d'un bug
    • Processing XML from external services, XSLT transformations and the XML of an RSA key no longer resolves external entities or external resources, which closes an attack route through untrusted text.
  17. Prevent SQL injection through large value lists on MySQL and PostgreSQL
    • Correction d'un bug
    • Text values placed directly in a statement for large IN lists are escaped correctly on MySQL and MariaDB. On PostgreSQL the session now enforces standard conforming strings and checks the setting.
  18. Safer handling of web requests
    • Amélioration
    • Web requests no longer accept Brotli compressed answers, because the Brotli decoder of .NET before 10.0.14 has a memory write flaw. Values of security-sensitive headers are masked in diagnostic output, and reading an answer ends with a time-out error when it does not finish in time.
  19. Number to speech supports fifteen more languages
    • Amélioration
    • The SQL function that spells out a number in words now supports English, German, French, Italian, Spanish, Arabic, Czech, Danish, Finnish, Japanese, Korean, Norwegian Bokmal, Polish, Portuguese and Swedish. Before, only Dutch was supported.
  20. Exact Online: companies outside the service area are not offered
    • Amélioration
    • Exact Online divisions of companies in countries on a compliance exclusion list, or outside the service area, are no longer available, except for a fixed list of companies that were allowed before. Divisions that do not allow reading are skipped and a warning is logged.
  21. Oracle: tables and views with mixed-case names can be queried
    • Amélioration
    • Names of Oracle tables, views and owners that were created with a quoted mixed-case name are no longer forced to the standard casing. The name as typed and the name in the usual Oracle casing are both tried.
  22. DBMS output tab handles very large output volumes
    • Amélioration
    • The DBMS output tab in the Query Tool uses a new line store and view so that large volumes of output can be shown. The output buffer on the database side is no longer limited in size.
  23. Twinfield: more offices per session
    • Amélioration
    • The maximum number of Twinfield offices that one session can use with an application supplied by Invantive is raised from 37 to 370. The new setting additional-allowed-offices names further offices that may be used.
  24. Aborting a running query works again on current .NET
    • Correction d'un bug
    • Pressing abort during a query or script run did not stop it cleanly, because the method used before is not supported on current .NET. The abort request is now passed through a cancellation token and ends the run quietly.
  25. Release 25.0 and 26.0 can run on one device with shared user settings
    • Amélioration
    • The user settings file now has a format version and keeps the licence keys of both licensing systems apart. Settings written by a newer release are read without losing unknown parts, and the deprecated connections element is read again. This helps when products of release 25.0 and 26.0 are installed on the same device.

Toutes les améliorations

Modifications apportées au comportement, aux plateformes, aux chauffeurs et aux paramètres, regroupées par domaine.

Importance: tout | 2 et plus | 3 et plus | 4 et plus | 5

Plate-forme: tout | ActiveCampaign (1) | AFAS Online (1) | Brevo (1) | Chargebee (1) | Crisp (2) | Data Cache (1) | DeepL (1) | Exact Online (19) | File system (2) | Fortnox (1) | Gripp CRM (1) | HubSpot (1) | Inspectlet (1) | Invantive Script (1) | ionBIZ (1) | LDAP (1) | LibreOffice (1) | Loket (1) | Matomo (1) | Microsoft Access (1) | MySQL (2) | Nextcloud (1) | Nmbrs (1) | OData (1) | Odoo (1) | Oracle (7) | Outlook (1) | Pipedrive (1) | PostgreSQL (6) | SnelStart (3) | SQL Server (5) | Teamleader (1) | Teamleader Focus (1) | Tweede Kamer (1) | Twinfield (3) | VIES (1) | Visma Severa (1) | Visma.net (2) | Windows (1) | Yuki (3)

1 sur 142 affiché(s).

Scripting

A script can query its own execution profile

Runs of Invantive Script, their statements, started operating system commands and script variables are registered and can be queried with plain SQL through the new data container Script and the data dictionary. Duration, CPU use, rows touched, exit codes and output volume are available. Statement text can be anonymised and variable values masked.

  • Invantive Script
  • importance 4

Service drivers of Invantive UniversalSQL

Toutes les corrections de bogues

Problèmes de l'ancienne version qui ont été corrigés.

Aucun.

Sur quoi cela s'appuie-t-il ?

Genre Nom De À
invantive component Invantive Query Tool 25.0.233 26.0.370
invantive component Invantive Producer Windows 25.0.233 26.0.370
invantive component Invantive Producer Base 25.0.233 26.0.370
invantive component Invantive Producer Data 25.0.233 26.0.370
invantive component Invantive SQL for Core 25.0.233 26.0.370
invantive component Invantive SQL for Windows 25.0.233 26.0.370
invantive component Invantive SQL 25.0.233 26.0.370
invantive component Invantive Basics 25.0.233 26.0.370
build tool Invantive Deploy 25.0.233 26.0.370
build tool change Windows installer now packages the .NET 10 build instead of the .NET Framework 4.8 build
build tool change Installer rejects more placeholder e-mail addresses and phone numbers
build tool change Log opened from the installer exit dialog ends with an 'End of File' line
build tool change Installer picks up language folders for Catalan, Hungarian and Romanian
build tool change List of supported Windows versions shown with the product is updated
target framework Invantive.Producer:src/Invantive.Producer.QueryTool/Invantive.Producer.QueryTool.csproj net48;net8.0-windows;net9.0-windows10.0.17763.0 net10.0-windows10.0.17763.0
target framework Invantive.Producer:src/Invantive.Producer.QueryTool.Setup/Invantive.Producer.QueryTool.Setup.csproj net48 net48
target framework Invantive.Producer:src/Invantive.Producer.Windows.Forms/Invantive.Producer.Windows.Forms.csproj net48;net8.0-windows;net9.0-windows net48;net10.0-windows10.0.17763.0
third party changed Oracle.ManagedDataAccess 21.18.0 23.26.100
third party changed Oracle.ManagedDataAccess.Core 3.21.180 23.26.100
third party changed MySql.Data 8.0.32.1 9.6.0
third party changed Npgsql 8.0.7 10.0.2, 8.0.9
third party changed Microsoft.Data.SqlClient 6.1.1 7.0.2
third party changed Microsoft.SqlServer.SqlManagementObjects 172.64.0 181.15.0
third party changed FluentFTP 39.4.0 53.0.2
third party changed SSH.NET 2024.2.0 2025.1.0
third party changed EPPlus 8.0.5 8.5.0
third party changed QuestPDF 2025.4.0 2026.2.3
third party changed Microsoft.Web.WebView2 1.0.3179.45 1.0.3856.49
third party changed AWSSDK.S3 3.7.416.5 4.0.19
third party changed Elastic.Clients.Elasticsearch 8.17.3 9.4.0
third party changed Fluent.Ribbon 10.1.0 10.0.4
third party changed Microsoft.Windows.Compatibility 6.0.9, 8.0.14, 9.0.4 10.0.5
third party added QRCoder 1.7.0
third party added System.DirectoryServices 10.0.5
third party added ZstdSharp.Port 0.8.8
third party summary

Plus d'informations

Comment cette note a été rédigée

  • All 31 exclusions confirmed; of 21 flagged items 12 were already in 25.0 (excluded), 6 new, 3 partly new (text narrowed).
  • Range: commits of origin/release-26.0 that are not in origin/release-25.0 and have no equivalent patch there (git cherry).
  • Scope: commits that touch a project of the product, found through the solution and its project references; test projects are left out.
  • Version stamp commits of the build pipeline are left out.
  • A change whose changed lines are for 70 % or more already in the tip of release-25.0 is left out (backport under another hash); items between 50 % and 70 % and all exclusions were then checked by reading the 25.0 code.
  • A bug fix whose repaired lines were written by another commit of the same range is merged into its feature or left out.
  • Texts were written from the commit messages and from the changes themselves; items carry a confidence.
  • 519 liens entre une modification et un commit source sont enregistrés.
  • 55 exclusions sont consignées dans le rapport d'audit de la note.