Switch to: V10V9V8V7V6V5

Valentina Release 10.5.x Notes

Release 10.5

2020-09-10

Valentina Studio

  • [New] Valentina Studio Single Edition.
    • At $79 you get all PRO features for a single DB, except Valentina Project {reports, forms, JS}.
  • [New][Form Editor][Pro]
    • Startup script. You can define some script to be a startup, so when a Valentina Project is opened, this script will be executed automatically.
    • Allow executing forms as non-modal dialogs.
    • Added/updated JavaScript code templates to import scripts and show modal and non-modal forms, they can be found in the Project section.
    • Cloud example with Forms 'Car_Catalog'. Read more...
      • This example shows how to develop forms, modal dialogs, write JavaScripts which control all this, and produce reports for printing, view on WEB or send by email.
  • [New][Script Editor][Pro]
    • Allow recursive imports.
    • Added autocompletion for imports (not supported import of scripts with 'as' yet).
    • Show code templates in scripts.
  • [New][SQL Editor]
    • [Pro] - UNSAFE Commands. SQL Editor will warn you in case of an unsafe command. This is UPDATE or DELETE without WHERE clause, which can change the whole table.
    • [Free] - Auto-completion of RegEx style.
      • [New][Preference] - option to choose between new RegEx style and the old StartWith style.
  • [Imp][Report Editor] Set the maximal editor layout zoom to 4x (user request)
  • [Imp][Form Editor] Improved drawing images on HiDPI/Retina screen.
  • [Imp][Form Editor] Dialog to load an image now allows zooming in and out.
  • [Imp][Form Editor] Added 'editTriggers' property to TableView which allows redefining the default editing behavior (e.g. perform custom script on double-click on the cell).
  • [Imp][Server Admin] Show full last query text in the tooltip.
  • [Fix][Data Editor][Valentina] Fixed showing NULL BLOBs/Pictures.
  • [Fix][SQL Editor] Fixed undo after autocompletion.
  • [Fix][SSH] Fixed failed connection when Password and then Key file are defined for the SSH connection. Always save either Password or Key file to the bookmark depending on the user choice.

Valentina Reports

  • [Fix] Fixed export of SVG images to HTML when scaling is ON.
  • [Fix] Fixed rendering wrong pictures for empty/NULL field data.

Valentina Kernel

  • [Imp] Enabled SQLite FTS5 extension (for SQLite databases, local and on Valentina Server).

Valentina Wiki

Release 10.5.1

2020-09-27

Valentina Studio

  • [New] Menu command “Add To Bookmarks…” on Bonjour discovered items.
  • [New] Menu command “Add To BookMarks…” on a live connection in Schema Editor.
  • [New] Menu command “Discover Localhost Servers” in the menu of Bookmarks column of the Start Page.
  • [Fix] Fixed LParser SkipComment for the case if parsed text starts with a multiline comment. This bug caused a crash for an MSSQL user.
  • [Fix]8864[Data Editor] - Slow vertical scrolling when a table contains a lot of fields.

Valentina for Xojo

  • [Fix] crash when a bind parameter is an empty string, working with vserver.

Release 10.5.2

2020-10-03

Valentina Studio

  • MAS version updated to 10.5.2 release.
  • [Imp] Made Data Editor error text selectable, also show it in the tooltip, it helps if the message is too long
  • [Fix] Fixed missing FKs/PKs in PostgreSQL link after a refresh.
  • [Fix] Fixed showing parameters panel of the SQL Editor in VStudio Single edition.
  • [Fix] Fixed adding tables/views/links from the left panel of the Query Editor.
  • [Fix] Fixed adding tables from the right panel of the Query Editor.

Valentina Reports

  • [Fix]8874 - Fixed wrong height of the rectangle in some conditions.

Valentina for Xojo

  • [Fix] Solved V4RB issue in RBDB Valentina that after close-open an object somehow became invalid – methods were not called by Xojo.

Valentina DB

  • [Fix]8872 - Crash on reading result of the query containing bind parameters in the select list

Release 10.5.3

2020-10-15

Valentina Studio

  • [New][PostgreSQL] - new controls in the Connect dialog to support new SSL
    • Show default paths to SSL keys
    • [VReports] - changes to support extended SSL params for PsotgreSQL
  • [New][Project Editor][Prefs] - Added preferences panel with options to manage double-click behavior for reports and forms
    • Choose between 'open for editing' or 'executing' (user request).
  • [Imp]8881 - Improve AutoComplete menu
    • It has now a status bar, where we can show some tips
    • it is possible to change the size of the menu virtually by mouse dragging its bottom edge.
    • In the status bar present menu where you can easily switch between “StartWith” and “RegEx” modes of autocompletion.
  • [Imp][Project Editor][Prefs] - Added option to disable restoring the previous selection, which helps if the lastly selected report crashed.
  • [Fix][Query Editor] - fixed creation of a link between tables.

Valentina Reports

  • [Imp] improve algs for Recursive Reports, especially for Windows and Mac.
  • [Imp] Cache NULL values - it allows the summary control with COUNT(fldName) function to skip records with NULLs

Valentina DB

  • [Imp][vKernel] “SHOW CONNECTIONS” - a new column fld_port
  • [Fix] - grow of RAM usage. The issue was technically in the VKERNEL code but did appear in the VServer under heavy load.

Valentina Server

  • [Imp] Minor improvements in vServer log.
  • [Fix] - grow of RAM usage.
  • [Fix]8873 - stuck with “Sending notification error”.

Release 10.5.4

2020-10-20

Valentina Studio

  • [Imp][Form Editor] - allow the recursive import of forms.
  • [Imp][Sql Editor] - tooltips for Table and View more informative.
  • [Imp][Sql Editor] - highlight instances of a word at caret position.

Valentina Reports

  • [New][vReport] New error - ERR_REPORT_PRINTER
  • [Fix]8842 - The last column of labels is not printed even if there is enough space for it.

Valentina DB

  • [Fix]8884 - Endless loop on update value in KeyValue

Valentina Server

  • [Fix]8882 - Incorrect VSet after passing it from vServer.

Valentina for Python

  • [New] allows connecting to SQLite databases, local or under Valentina SQLite Server.
    • conn = valentina.connect('vsqlite://sa:sa@127.0.0.1/db')
  • [Lix] correct vresources location in Linux packages

Release 10.5.5

2020-10-22

Valentina Studio

  • [Fix][Import Wizard] Enabled loading/saving mapping in VStudio Single.
  • [Imp][Win] – Improved performance of loading schema objects in the Schema Editor (specifically opening the 'public' schema in the tree mode).

Valentina Server

  • [Fix][RPi][SQLite] – Fixed opening SQLite databases larger than 2.1GB in Valentina Server for ARM architecture.

Valentina NET

  • [Fix] crash in the VField.Find() method if return result is empty.

Valentina for Revolution/LiveCode

  • Fixed compilation of standalone applications, other improvements.

Note: it is necessary to control whether the Valentina engine was inited before calling Valentina_ShutDown in handle_close (for example, using global flags in stacks). Also, there could be more Valentina calls in close_handler like close connection, database, etc…

Release 10.5.6

2020-11-09

Valentina Studio

  • [New][Form Editor] Added project.getItemByName() method to use in JavaScript. For example, to change the datasource definition in code.
  • [New][Form EDitor] 8892 Add ability to pass default options to report.showPrintDialog called from JavaScript
  • [Imp][Form Editor] Added enum PROJECT_ITEM_TYPE to use with project.getItemByName().
  • [Fix][Form Editor] Fixed copy&paste of ComboBox control.
  • [Fix][Form Editor] 8851 - Valentina Studio Form Editor do not respect characters encodings.
  • [New][Diagram Editor]8880
    • Added ability to set color/font for each sub item (in the property inspector)
    • Added property to set the default font for the whole diagram
    • Added paper format/orientation in PDF export
    • Fix scrollbar position on update property inspector and other small fixes
  • [New][Query Editor]8894: Support composite foreign keys in the Query Editor
    • Supported drawing links on multiple columns
  • [Fix]8865 - Not highliting comments + not respecting cursor blink
  • [Fix]8875 - Fix zoom in the label layout.
  • [Fix]8890 - Ctrl+v doesn't work in SQL Editor when multiple Valentina Studio windows are open.
  • [Fix][VServer Admin]8895 - Column headers don't correspond to the data in “Server Admin/Connections”.

Valentina Server

  • [Fix]8873 - vServer stuck with “Sending notification error”
    • New message for the log: “Notification connection has been paired with regular connection (UID %d).”

Valentina Wiki

Release 10.5.7

2020-11-29

Valentina Studio

  • [Imp][Reports] - count controls from subreports on stretch controls.
  • [Fix][Reports] - count controls from a subreport that starts new page.
  • [Fix][Form Editor] ignore changes of the current item in ComboBox on add/remove items, auto-update current item after changes.
  • [Fix]8899[Query Editor] - JOIN tables in the same order as they were added to the Query Editor diagram.
  • [Fix]8900[Query Editor] Existing links between PostgreSQL tables are not shown on the Query Editor diagram after reopen
  • [Fix][Query Editor] Small fix - corrected position of the link attachment point if key fields were added to the existing link.
  • [Fix]8898 - Set correct positions of all reordered columns when applying Data Editor Layout.
  • [PostgreSQL] client libs updated to 13.1.

Valentina Server

  • [Fix]8873 - vServer stuck with “Sending notification error” - more improvements.