Switch to: V12V11V10V9V8V7V6V5

Valentina Release 9.0 Notes

Release 9.0.0


Valentina Studio

  • [New][Mac] Qt framework upgraded to 5.12
    • This sets minimal Mac OS to 10.12
  • [New][Project Window] now has ICON VIEW for project items, additionally to LIST VIEW.
  • [New][Project Window] now shows a preview of reports.
  • [New][SQL Editor] Static Analyzer errors indicator.
  • [New][SQL Editor] Static Analyzer console panel where you can see all errors found by the analyzer.
  • [New][SQL Editor] has menu Default Schemas for PostgreSQL and MSSQL. This allows you to see which schema(s) is currently the default, and allows you to change it.
  • [New][Schema Editor] Ability to create events for Valentina Studio Projects.
  • [Imp] Improved speed of the data preview in Schema Editor tree view mode for tables with large BLOB values.
  • [Imp] SQLite engine upgrade up to 3.26
  • [Fix]8452 ImageEditor shows wrong picture
  • [Fix][Data Editor] Fixed duplicating records with BLOB values.
  • Valentina Studio IS ABLE to work with older Valentina Servers.

Valentina Server

  • [New][SQL] 7966 Enables the Scheduler of Valentina Server to work with a backup of a Valentina Project
  • [New][SQL] 8449 SET PASSWORD OF [USER] username IDENTIFIED BY old_password TO new_password
  • [Chg] Protocol. Both client and server must be upgraded to 9.0
  • [Imp] SQLite engine upgrade up to 3.26

Valentina DB Client

  • [Chg] Protocol. Both client and server must be upgraded to 9.0

Valentina DB

  • [New] 8325 Arrays in Stored Procedures
    • DECLARE days BOOLEAN[7];
    • SET days = ARRAY[false,true,false,false,false,false,false];
    • SET days[2] = TRUE;
  • [Chg] 8458 RENAME funcs ENODE / DECODE to STR_ENODE / STR_DECODE, because ENCODE is a keyword.
  • [Fix] 8273 Wiki Examples of MERGE command of Valentina SQL.

Valentina DB ADK (any)

  • [Chg] 8252 API way only.
    • Removed any mentions of BitSet and ArraySet classes.
    • Removed few methods in VField class with names of these classes, e.g. FindAsArraySet()
    • If your code did use these methods you need change code to use FindVaue() etc search methods of VField class.
    • SQL way works as before.
  • [Imp] SQLite engine upgrade up to 3.26

Valentina for Xojo

  • [Imp] 8457 Improve internal threading inside of V4RB plugin when a long operation happens.

Release 9.0.3


Valentina Studio

  • [Imp][Mac] upgrade to QT 5.12.1
    • [Fix] this fixes the issue with fonts on 10.14 + non-retina external displays.
  • [Imp][Mac] Schema Editor, Column View, trackpad dragging by horizontal.

Release 9.0.7


Valentina Studio

  • [New][Form Editor] Allowed to use aliases in ComboBox and ListView, allowed to use the script as source data.
  • [New][Form Editor] Allowed filling lists from a query.
  • [New][Report Editor][Form Editor] Added macro $P!(param) for parameter that shouldn't be quoted as literal (like SELECT * FROM $P!(table_name))
  • [Fix][Postgres] Set sequence default cache value to 1.
  • [Fix] 8474 When adding a new sequence, allow more digits in the “max value” field.

Valentina Reports

  • [Imp] Value for a parameter in the subreport query now is taken from the main report if it is not defined, for example, in the map of parameters.

Valentina for Xojo

  • [Fix][Win] fixed installer issue, PATH variable to vcomponents_x64 did not have disk name
  • [New] 8472 Valentina.YieldMode property. Default state is “true”.
    • If true then we do YieldRunner inside most of V4RB calls for better UI (no beach balls and “app not responding” state) within long Valentina calls. You may set it to false in some circumstances like this one.
    • Was required for Console-only apps
    • Can be used to speed-up many small calls in a hot loop, e.g. many SqlExecute( “INSERT INTO …” )