Valentina Release 9.1.x Notes

2019-03-22

• [New][Forms] Added code templates for import of the forms and scripts.
• [New][Forms] Implement autocompletion for imported forms and scripts (partially).
• [New][Forms] Call 'needUpdate' slots on click buttons, edit text etc., to update dialogs not linked to a datasource.
• [New][Forms] 8131 Add property “Mode” for the LineEdit-Field control.
• [New][Forms] Added 'application.sessionStorage' object to store and pass data during single session.
• [New][Updates] 8486 Add ability to check for updates using the proxy connection.
• [New][Schema Editor] Add button to toggle preview panel in Schema Editor for tree mode.

• [Imp] General improvements to application icons.
• [Imp][Sql Editor] Opt-Click on an object name now selects this object in the tree, instead of opening another Schema Editor dialog.

• [Fix][Sql Editor] 8485 display non-printable chars in sql-editor.
• [Fix][Data Editor] Fixed an issue when pasting tabular data to a database with schemas.

• [Fix] 5259 Fix execute query and refresh result on readwrite cursor.
• [Fix] 7300 Almost unable to read selected row in table if using dark theme on Linux (KDE).
• [Fix] 7793 Renamed SQL Snippet is duplicated after application restart - with an old and a new name.
• [Fix] 8468 Turning off sort fields does not work completely.
• [Fix] 8470 Form Editor: NULL values are not handled in the ComboBox.
• [Fix] 8479 Rightmost column sometimes is not visible.
• [Fix] 8486 Add ability to check for updates using the proxy connection.

• [New] Docker for Valentina Server, on Linux, Mac OS X and Windows.
  • Valentina Server Docker Documentation

• [New] Totally a new additional way to do SQL Dump. Resolve a problem when DB have really HUGE blob data.
  • VDatabase.DumpEx()
  • VDatabase.LoadDumpEx()

• [Win] Total re-write of VODBC driver.
  • [New] 64-bit archive, additionally to 32-bit.
  • removed dependency on WX framework.

2019-03-29

• [New][Form Editor] Allow sorting records, added methods: addSort(), removeSort(), applySorts(), clearSorts().
• [New][Form Editor] Add templates of JS code to sort records.
• [New][Form Editor] Allow to setup sorting via Property Inspector.

• [Fix][Data Transfer] Transfer of database with schemas.
• [Fix][Schema Editor] Resize columns of a table with properties in the tree mode.

• [Fix] 8475 Need to limit auto width of columns to parent table width.
• [Fix] 8487 F5 does not refresh Data Editor.

• [Imp] One more attempt to make better threading of long tasks for Xojo.
  • Now our YieldRunner uses own approach instead of MySQL plugin.
  • Database_Diagnose now has Progress Bar and demonstrates how to use Xojo Thread and V4RB to avoid “app not responding” state.

2019-04-07

• [Imp][PROJECT PLUGIN] don't open report's page on double click in viewer mode.

• [Imp] 8493 [Data Transfer] Update the current value of the sequence with a maximum/minimum value of the imported data, to avoid key duplication errors during the subsequent inserts (Valentina DB, PostgreSQL, MS SQL).

• [Imp] [Data Transfer] Removed unnecessary queries to updates the record count during transfer.

• [Fix] Fixed rendering editors tabs on the diagram to show complete object name.

• [Fix] [Error Lookup] Fixed an error message during the Valentina engine message lookup.

• [Fix] 8492: Random error message getting data from the types of the different fields.

• [Fix] 8495: Crash while iterating cursor with string data (specific to DE symbols). UTF converters.

2019-04-26

• [Imp] About a dozen small fixes in Forms.
• [Imp] MariaDB upgraded to v3.1 (fixed bug https://jira.mariadb.org/browse/CONC-364).

• [Fix][MySQL] Fixed showing added record in the Data Editor when the value of the autoincremented key is defined manually.

• [Fix] 8496: Dragging tables to diagrams in databases with schemas.
• [Fix] 8500: Valentina Studio do not show error, when no permission to access table.
• [Fix] 8501: Crash in analyzer for '[“a”, {“b”:1}]'::jsonb #- '{1,b}'
• [Fix] 8502: “Format SQL Query” corrupts query when using.

• [New] 8508[RBDB]: ADD db.EmbeddedSerial property for vSQLite, for VDN users.
• [New] 8509[RBDB]: ADD Valentina Server properties/methods - PortSSL, UseSSL, UseNotifications.

• [Fix] 8506: Default V4RB_YieldMode value must be false.

• [Fix] 8504: Serious issues with string function str_encode().
• [Fix] 8510: RAND_REGEXP returns NULL for any pattern on Windows [10].

2019-05-02, VSTUDIO only.

• [Fix] 8514: Schemas/tables not showing in the left panel after updating to 9.1.3.
• [Fix][Form Editor] fix hide button to reset edited value.
• [Fix][PostgreSQL] Fixed missing function arguments after schema refresh.
• [Fix][Diagrams] Fixed missing control action icons when zoomed and on Retina screen.
• [Fix][Diagrams] Returned back text aliasing for Retina.
• [Fix][Report Editor] Hide CrossTab control in the release build, it is not ready yet.

2019-05-13

• [New][SqlEditor] Use Cmd/Ctrl + ` to toggle recents/editor.
• [New][SqlEditor] Use Cmd/Ctrl + 1/2/3/4 to switch tabs in the left panel of SQL Editor.

• [New][SqlEditor] “Duplicate Line” command renamed to “Duplicate Line(s)” - now you can select few lines and CMD+D will duplicate them.

• [Fix] 8484[PostgreSql]: The first Query Hangs.
• [Fix] 8510: “Format SQL Query” corrupts query when using ON DELETE
• [Fix] 8516: SQL-Server Query returns inconsistent results instead of error.
• [Fix] 8519: SqlAnalyser show not resolved idents in the valid query with FIRST( … ORDER BY …)
• [Fix] 8527: Unable to use SQLite Server Database as a data source in the LOCAL project if database file has an extension.

• [Fix][SqlAnalyzer][VDB] sometimes, on the first use of OID field it was marked as not recognized.
• [Fix][SqlAnalyzer] now knows to CREATE/DROP/ALTER schema commands.

• [Fix] 8513: Ability to define any condition for INNER JOIN, affects also MERGE.