Switch to: V10V9V8V7V6V5

Valentina Release 10.4.x Notes

These release notes describe the changes in Paradigma Software Valentina products beginning with Release 10.4 and through the 10.4 life cycle.

These release notes are organized by individual release and product. They are updated periodically as new information becomes available within a specific release as well as before or after a specific release. To ensure that you are reading the latest version of the release notes, visit the top page of the Valentina Release History. You should always consult the latest release notes prior to installing a new version. Some products have technologies shared by others, and you can assume that a technology listed under one product will likely be rolled into products that use that technology.

Release 10.4.0

2020-05-20

MacOS

  • Finally we switching our build-computers from Xcode 9.4.1 to Xcode 11.3.1
    • Now we cannot build 32-bit
    • So we remove finally 32-bit DLLs from V4RB and V4REV. All other products many years were as 64-bit only.

If you still require 32-bit compatibility on macOS, do not upgrade to Valentina Release 10.4 on macOS. You should continue to use Valentina Release 10.3.

Valentina Studio

  • [New][Mac] Switch from Qt 5.13.1 to 5.14.2
    • Valentina Studio inherits all fixes and improvements in Qt 5.14.2
    • Supports Dark Theme of MacOS.

Valentina Studio 10.4 requires macOS 10.13 or later.

  • [New][Project Window] now has preview of reports.
  • [New][SQL Editor]
    • [New] Snippets panel now uses the “S” button to display scope for each snippet - scope map.
    • [New] Scope map displays 2 circles for each snippet to visualize scope ownership.
    • [New] Click on the scope map circles to add/remove a snippet to the “Global” / “Current DB” scope.
    • [New] tooltip of a snippet now displays also its scope: “Global” / “Current DB”

  • [Imp][Query Editor]8154 Display RecID/OID fields for Valentina DB.

Valentina Reports

  • [Imp] HTML control now by default produces HTML in the iframe tag,
    • and you have option return back: HTML as picture.

Release 10.4.1

2020-05-22

Valentina Studio

  • [Fix][Dark Theme] AlternateBase palette color not changing on macOS
  • [Fix][Report Editor]
    • Fixed rendering images in layout mode on a retina screen.
    • Set left/right indents of a new picture to 0
  • [Fix][SQL Diff] SQL DIFF several issues

Release 10.4.2

2020-05-26

Valentina Studio

  • [New][REPORT EDITOR] Select alpha/opacity for Text and Borders
  • Improved stability
  • [Fix][SQL Diff] DIFF with databases that have schemas and constraints with the same name in different schemas

Valentina Reports

  • [New] alpha/opacity for a text and borders

Valentina DB

  • Improved stability.

Release 10.4.3

2020-06-08

Valentina Studio

  • [New][DataEditor][Pro] - EXPORT BUTTON,
    • which allows you to export a visible set of rows from Data Editor to CVS, Excel, HTML, JSON formats or copy to clipboard.
    • This is similar to button in SQL Editor but allows you do export easy and fast without writing SQL query.
    • This export takes into account the order of fields in Data Editor (which you can control using Layouts).

  • [Imp][Data Editor]
    • Decreased the default width of columns.
    • Corrected the column width for a column with an icon (FK, PK).
    • Corrected column widths (add more space for the field name)
    • Added the preference “Default maximum column width”, which is used if a column content is too long.

Valentina Server

  • [Fix]8800 - Improved stability if the INI file is absent or somehow incorrect.

Valentina Reports

  • [New] SVG picture now can be stored in a textual field. You can now specify such a field as a data source for the picture control.
  • [Fix]8804 - When “column_layout=Right” an extra distance was added between rows of labels.

Valentina DB

  • [Imp][SQL] Now can be a comma-separated list of variables in the SET clause:
    • “SET @a = 1, @b = 2, @c = 3;”
  • [Fix]8805 - Corrupted unique index because of data's unique violation.
    • Few fixes made in this area: UNIQUE INDEX and operations when it present.
    • Diagnose now can provide more useful details

Valentina for Xojo

  • [Fix]8807 - New RBDB db.ExecuteSQL() syntax produces no result for query with binding.

Release 10.4.5

2020-06-15

Valentina Studio

  • [Imp] Many places polished to better work with Dark Thema.
  • [Imp][Data Editor] Filter cell now can skip $ in the first expression: ”> 10 and $ < 20”.
  • [Fix][Data Editor] in work of Filter → Recent menu.
  • [Imp][Sql Editor] contextual menu now has more commands.

Valentina Reports

  • [Imp] Allow to use quoted parameter names in expressions/queries, for example, $P('parameter') or $P(“parameter”)
  • [Imp] Log about missing parameters.
  • [Fix] Fixed picture control content indents.

Valentina DB

  • [Fix] non-indexed search in very old db with Big Endian could give wrong results, because of new optimization made about a year ago.
  • [Imp] improved the diagnose of a BLOB field to show RecIDs of problem-segments.

Release 10.4.6

2020-06-22

Valentina Studio

  • [Fix][Form Editor] load of forms in the old format.
  • [Fix][SQL Editor] Win and Linux - “Ctrl+E” shortcut was broken after extending of Contextual Menu.
  • [Fix] crash on refresh after dropping a table in MySQL.
  • [Fix][Data Editor] icon of boolean fields for dark mode and few other places.

Valentina Reports

  • [Fix][Win]8814 printing was always scaled down

Valentina for Xojo (V4RB)

  • [Imp] improved VSQLite examples to show how to create/open/create_if_not_exist databases locally or under vServer.

Release 10.4.10

2020-06-24

Valentina Studio

  • [Imp][Dark Mode]
    • Query Editor - fixed icon for the dark mode
    • Report Editor - corrected tabs style for report parts in the Dark Mode.
    • Report Editor - use standard QString::arg method for passing color values to the style.
    • Start Page - corrected color for deleted “Recent items” in lists.
  • [Fix]8817 - The lists of tables under schemas are not properly sorted in the Query Editor.
  • [Fix][Form Editor] few issues fixed and improved: contextual menu, docs, autocompletion, default values on adding a record, drag fields, …

Valentina DB

  • [Fix]8818 Issue which could cause BLOB corruption when Update() made with a cursor.
  • [Fix] Sorting of a field in Descending, when selected more than 50K records, in a special MT algorithm.
  • [Fix] Clone of damaged db could stop executing the clone of a BinaryLink because of exception. Now it will continue up to the end of Binary Link.

Release 10.4.12

2020-06-24

Valentina Studio

  • [MAS] - this version was pushed to Apple Mac AppStore.
  • [New]8403 - Ability to save/load the mapping info in the Import Wizard, to save time for the next runs.
  • [Imp][Dark Mode]
    • Import Wizard.
    • Schema Editor - error msgs.
  • [Fix]8824 -The list to select index fields is empty

Valentina Reports

  • [Imp] Reports and subreports now use the same JS context (global variables, etc).

Valentina DB

  • [Fix]8821 - Clone BinaryLink may produce wrong linked records or exception.
  • [Fix]8822 - Database with a dot in name produces a bunch of issues.
  • [Fix]8823 - Self-recursed M::M BInaryLink with NO_CASCADE deletion policy may leave records linked after delete some of them.

Release 10.4.14

2020-07-09

Valentina Studio

  • [New]8784 - [MariaDB] ed25519 authentication.
  • [New][Form Editor] - allows specifying a field to sort data from a field.
  • [Imp][Dark Mode]
    • Valentina Project Window.
    • Form Editor
    • All Wizards
  • [Fix][SQLite] Fixed non-working “New Index” action for SQLite database.
  • [Fix][Form Editor] - fix reset sorted/distinct flags for list from a field.
  • [Fix][Form Editor] - fixes for combobox with 'editable' flag.

Valentina Report

  • [New] allow removing the empty line with borders/lines

Valentina DB

  • [Fix] issue which could cause SegmentMap error.

Release 10.4.16

2020-07-22

Valentina Studio

  • [New][Project Editor] - previews for forms.
  • [New][Form Editor] - allow navigation inside of a layout using a keyboard.
  • [New][Form Editor] - log place of an unhandled exception.
  • [New][Form Editor] - add property 'Accept Rich Text' to TextEdit widget.
  • [Fix][Form Editor]
    • edit title of a form.
    • reset Combobox with a NULL value and without NULL entry.
    • allow setting custom text for NULL entry in Combobox.
    • copy-paste widgets by contextual menu.
    • not sorting widgets in the inspector.

Valentina Server

  • [New]8829 - 08829: Additional column “fld_cursors_size” for “SHOW CONNECTIONS”

Valentina DB

  • [Fix]8827 - fixed bug in INNER JOIN

Valentina for Xojo

  • [Fix]8813 - RBDB class VRBDatabase now has new properties to work with an encrypted database,

Release 10.4.18

2020-08-01

Valentina Studio

  • [New][FormEditor]
    • add 'QHeaderView' class, add QTableView properties
    • add methods scrollTo, scrollToBottom, scrollToTop
    • add QAction, QMenu classes
    • add 'clear' method to QTextEdit class
  • [Fix][FormEditor]
    • fix reconnect 'currentChanged' and 'selectionChanged' signals on update model of a table view
  • [Fix]8835 - Crash when disconnecting from a server
  • [Fix]8837 - [PostgreSQL] Crash on the refreshing database after dropping multiple schemas
  • [Fix]8837 - [MSSQL] Crash on the refreshing database after dropping multiple schemas

Valentina Report

  • [Fix]
    • skip NULL values in summaries
    • fix offset on remove last empty line in the area
    • fix background on remove empty lines
    • fix remove lines after subreport
    • fix insert subreports in the page footer

Valentina DB

  • [Fix]8834 - '__MAIL' command expects that attachment (defined as BASE64 string) starts with a newline character