Valentina Release 9.7.x Notes

14 Nov 2019

• [New][Report Editor] - property 'column_layout' with options: { “horizontal”, “vertical” } added for COLUMNS and LABELS reports.
  • Prior to release 9.7 only “vertical” order was supported
  • Please review the Valentina Reports documentation for more details

• [New][Schema Editor] - UPLOAD files to a Valentina Server
  • UPLOAD license file
  • UPLOAD ValentinaDB files
  • UPLOAD SQLite file
  • UPLOAD Valentina Project file
  • You can upload them through Valentina Server Admin in Valentina Studio through dialog or drag&drop
  • You can upload them via the contextual menu of “Valentina Server Connection”
  • You can drag files into the first column of Schema Editor
  • You can drag files to an active VSERVER CONNECTION on the left panel
  • You can drag even open local SQLite or Valentina DB from the first column of Schema Editor to an active VSERVER CONNECTION on the left panel

• [New][Server Admin]
  • Tab-panel “Licenses”, displays all licenses located in the VServer/licenses directory
    • Licenses have different colors depending on their status, Expired, Time Remaining and so on.

• [New][Project Editor] - Now you can edit a JavaScript file after a single click, instead just see its non-editable preview. This is similar to Xcode project behavior.

• [Imp][JS Script Editor] - adds a 'console' option to the auto-completion list

• [Fix][MSSQL][Data Editor] Fixed sorting by NText/Text columns in the Data Editor.
• [Fix][MSSQL]8622 - Error: “The next data type cannot be selected as DISTINCT because it is not comparable”
• [Fix]8633 - Auto-completion by ENTER button corrected.

• [New][VSQL]8674 - VServer poperty 'SERVERPATH' in the command 'GET PROPERTIES'.
• [New][VSQL]8677 - “DROP PROJECT proj_name” command.

• [Chg][VSQL]7338 - Now you can skip “USE MASTER;” command in 'CREATE/DROP/ALTER EVENT' commands.

• Valentina Server Docker
  • Improved documentation for Valentina Server on the Docker website: https://hub.docker.com/r/paradigmasoft/valentina-server
  • Improved documentation on the Valentina Documentation wiki

• [New] Report with columns can now fill columns in the “horizontal” order, additionally to original “vertical” order.

Horizontal Order	Vertical Order

• [New][SQL] “REPAIR DATABASE”, “REPAIR TABLE table_name, …”, “REPAIR FIELD tbl_name.fld_name, …” commands
  • Currently it is able to fix 1 kind of corruption in a BLOB field
  • Speed of repair is now much faster than reindex or clone

22 Nov 2019

• [Fix]8672 - Double click on error does not move text on the line with error.
• [Fix]8685[Lin] - Dark theme can be chosen.

• [Fix] crash in the new REPAIR method on a Calculated Field of BLOB/TEXT type.

2 Dec 2019

• [Fix][SQLDiff] Fixed showing the name of a changed function (readable parameter types), turned off word wrap for the result table.
• [Fix][Data Transfer] tool now works for databases with schemas
• [Fix][Data Editor] fixed not-scrolling horizontally checkbox to mark all records.
• [Fix]8694[Mac] - Can't quit the application after switching to the fullscreen mode on macOS

• [Imp] Diagnose of Table now do 3 additional checks of data consistency.

• [Fix] crash in Diagnose() - new rare case found.
• [Fix]8692 - wrong result using “operator →”. New regression test added.

13 Dec 2019

• [New][Mac] QT 5.13.1 now is used (it was QT 5.12.1)
  • This should bring few fixed bugs in QT, for example, fix of TAB-panels move.

• [New][SQL Editor] Working with MySQL, can filter-out command “DELIMITER delim”.

• [New][PostgreSQL] Added function category property (FUNCTION or PROCEDURE), fixed Generate SQL for procedures, supported creating procedures in Create Function Dialog
• [New][PostgreSQL] Show readable function arguments in DROP confirmation dialog

• [New] For ValentinaDB RBDB and SQLite RBDB API, added a new method of Xojo 2019 r2.1 - PreparedStatment.ExecuteSQL()
  • For older builds of Xojo, this method is not registered of course.

20 Dec 2019

• [Fix][SQL Editor][MySQL] fixes in filtering out of DELIMITER commands.

• [Fix]8700 - crash in cast.
• [Fix][SQL] for ULLONG field correct INSERT INTO … VALUES (some big value with last bit 1)

• [Imp] REPAIR command