Switch to: V14V13V12V11V10V9V8V7V6V5

Valentina Release 12.5.x Notes

Release 12.5.0

2022-08-01

Valentina Studio

  • [Imp] - switch to Qt 6.3 on all OS. Before was Qt5.3
    • [New][Mac] - introduced ARM version of Valentina Studio.
    • [Chg][Win] - Qt6 does not support Win7/Win8
  • [New][SQL Editor] - placeholders in SQL text when:
    • [New] - an auto-complete suggestion is inserted
    • [New] - auto-complete insert a built-in or User-Defined function with arguments as placeholders
    • [New] - a snippet is inserted
    • [New] - template of SQL command is inserted
    • [New] - Table → Generate SQL → INSERT: provides placeholders in the VALUE part.
    • [New][Wiki] placeholders page.

  • [New][DataEditor] – Filter cell now can contain a few values as a comma-separated list. This will be used as SQL search with “fld IN (value1, value2, …)”.
  • [Fix][Data Editor]7838 - Improve FILTER for Boolean fields:
    • now 0/1 in a filter-row are replaced with FALSE/TRUE for PostgreSQL
    • IS TRUE/IS NOT TRUE/IS FALSE/IS NOT FALSE filters are supported for all databases
  • [Fix][SQL Editor]7930 - SQL formatting is incorrect for comments where “–” is preceded by a character
  • [Fix][Query Editor]8217 - Update the generated query by clicking the “Select All” checkbox if some fields have already been selected.
  • [Fix][Schema Editor][SQLite]9105 - 'Default Value' during design Table.

Valentina DB

  • [Imp][BLOB]9119 - The speed of BLOB UPDATE will grow even more compared to improve in 12.4.4
    • yet in 5-10* times
    • (!!!) CHANGES in db format for BLOB fields.
    • (!!!) Please backup your database BEFORE opening it in the 12.5, because conversion is automatic, and there is no back-conversion.
  • [Info] - we have switched all our projects to CPP'20 standard.

Release 12.5.1

2022-08-04

Valentina Studio

  • [Fix][Mac] crash on the internal assert of Qt.
  • [Fix]9118 - Fix filtering by Date/Time fields in the Data Editor

Valentina Server

  • [Fix] possible deadlock found.

Valentina C SDK

  • [Imp] - Added an ability to call Valentina_SetDebugLevel(0) before Valentina_Init() to avoid the creation of the log file

Release 12.5.2

2022-08-12

Valentina Client

  • [Upd] - OpenSSL updated to 1.1.1q (and some related libraries)
    • [Imp][Mac] - compiled with ARM flags

Valentina Studio

  • [Upd][Mac][MSSQL] - Updated FreeTDS to 1.3.12
  • [Imp] - German translation.
  • [Fix][Mac][Arm] - now works connection to MSSQL Azure.
  • [Fix][SQL Editor] - crash on the editing of a literal with e.g Cyrillic chars.

Release 12.5.3

2022-08-17

Valentina Studio

  • [Fix][Data Editor] Fixed crash on editing a cell with the right border off the screen.
  • [Fix][MySQL] - Fixed creating and dumping a table with auto-incremented indexed field (non-PK, non-Unique).
  • [Fix]9128: Disabling Zoom only disables magnification.

Valentina for Xojo (V4RB)

  • [Fix] build script broken for 12.5.2 after our internal optimizations in CD/CI, as a result, ARM was lost in V4RB vcomponents, now it is back.

Valentina for Python ADK

  • [Imp][Mac] - now compiled with ARM option.

Release 12.5.4

2022-08-28

Valentina Reports

  • [New] - Added the ability to use JavaScript in the expression of the Summary control. Now it is possible to reference non-datasource objects of the report. It allows calculating summaries for Expression controls, e.g.: report.controls.expression1.instance.source.

Valentina Studio

  • [Imp][Data Editor] - Add predefined date/time formats to show them in the Combobox field of the 'Set Format…' dialog. Remember the last entered format.
  • [Fix][Data Editor] - fix apply a date format to new values for Valentina DB.
  • [Fix][MySQL] - Define the MySQL query generation rule to create an index before setting the AUTO_INCREMENT flag (produces better-formatted queries).
  • [Fix]9130 - Cannot close the bottom section of SQL Editor (Fixed the preference to disable static analyzer error console auto opening).

Valentina for Xojo

  • [Imp][Linux] - Add own 'libstdc+ +' to rpm package for v4rb, to be able to start it on older versions of Linux.

Release 12.5.5

2022-09-08

Valentina Studio

  • [Imp][MySQL] - Add 'Aria' to list of engines (default engine for system tables in MariaDB).
  • [Imp][MYSQL] - Added new keywords from MariaDB. Added Keywords
  • [Fix][MySQL] - Fix update Charset/Collation properties of a connection
  • [Fix][MSSQL]8494 - Enabled Schema and Start input fields in MS SQL Create Sequence dialog
  • [Fix][MSSQL]9134 - Fixed wrong display of MSSQL Sequence properties Start, Min Value, Max Value
  • [Fix][SQL Editor][MSSQL] - Fixed showing values of SQL_Variant fields in the SQL result

Valentina DB

  • [Opt]9139 - Binding for BLOBs - a redundant copy of data
  • [Fix]9132 - Crash on CSV import if the imported file doesn't exist.
  • [Fix]9138 - SHOW VIDENTS now show sequence names also.

Valentina for Python

  • [Fix] - Fixed an error on loading Valentina extension: [defclass] [methods_delete] [SchemaList] The method ‘set’ is marked as a child method of ‘I_ModelList’, but really is a child method of Parent, ProxyParent.

Release 12.5.6

2022-09-28

Valentina Studio

  • [Imp][Mac] - a little cosmetic polish Autocomplete menu
  • [Fix]9140[MSSQL] - User-defined types are not shown in the list of field types.
  • [Fix][MSSQL] - Show the correct tooltip for Variant type column

Valentina DB

  • [Fix]8706[VSQL] - Add the ability to specify parameters for the 'REPORT' SQL command and to pass JavaScript to RunScript method.
  • [Fix]9142[VSQL] - SHOW VERRORS missed some verror items.

Valentina DB ADK

  • [Fix]9143[VSQL] - Logging can't be used when APP is in the Application folder.
    • New logging for all ADKs:
      • Mac: ~/Library/Logs/inAppName/vlogs
      • Linux: ~/.cache/inAppName/vlogs
      • Win: HOMEDRIVE\HOMEPATH\Application Data\inAppName\vlogs

Valentina for Python

  • [Imp] - added debug-log to this plugin as it is in all other Valentina ADKs.
    • You can enable it using: valentina.setdebuglevel( 0..4 )
    • to force flush: valentina.setflusheachlog(True)

Release 12.5.7

2022-10-06

Valentina Studio

  • [Imp][MSSQL] - Updated Compatibility Level database property - added newer server versions, including 2022.
  • [Imp] - Improved crash dumps, which VStudio sends to Paradigma in case of a crash.

Valentina DB Server

  • [Fix]9133[Mac] - Can't open log files of vserver (permissions). Returned to previous logic.

Valentina DB

  • [Fix]9113 - Testing Boolean fields with IS TRUE/IS NOT TRUE produces an empty result.
  • [Fix]9145 - Setting numeric collation results in tertiary strength for the field.

Release 12.5.8

2022-10-15

Valentina Studio

  • [Imp] stability in a few places (most for MySQL).
  • [Imp][PostgreSQL] - Updated client and dump utilities to version 15.
  • [Imp][SQL Editor]
    • [Imp] IdentResolver now works for most ALTER and DROP commands.
    • [Imp] Autocomplete for CALL command.
  • [Fix][Data Editor] Fixed crash on saving the contents of the BLOB/Picture fields in the popup dialog on Windows and Linux.

Valentina DB

  • [Fix]9144 - Error message “Dynamic SQL error” when flushing

Release 12.5.9

2022-11-04 (VSTUDIO ONLY)

Valentina Studio

  • [Imp][SQL Editor] - Static Analyzer
    • Respects 'CREATE DOMAIN', and 'DROP DOMAIN' commands.
    • Respects 'CREATE SEQUENCE', and 'DROP SEQUENCE' commands.
    • SELECT tblAlias.fldName fldAlias
    • SELECT foo() fldAlias
  • [Imp][SQL Editor] - Ident Resolver
    • DROP commands respect now the [IF EXISTS] clause.
  • [Imp][SQL Editor] - Autocompletion
    • More names of DB objects extracted now from the supported DBMS.
      • For example: TYPE in VDB, UNIQUE in SQLite, etc.
  • [Fix][SQL Editor] - Tip for a sequence name.

Release 12.5.10

2022-12-07 (VSTUDIO ONLY)

Valentina Studio

  • [Fix][Reports] - Remove useless whitespace on wrapping a text.
  • [Fix]9152[Reports] - Fix wrapping of long text without punctuation and spaces.
  • [Fix]9154[Reports] - Rename property 'lines_interval' to 'leading'.
  • [Fix]9151 - Design Table window does not display field names sometimes.
  • [Fix]9157[VCLIENT PLUGIN] - Incorrect/different date separators in SHOW EVENTS.
  • [Fix] - hopefully, crash around TreeItem::DeleteChildren, mostly for Linux.