Switch to: V9V8V7V6V5

Valentina Release 8.3.x Notes

Release 8.3.0

2018-05-22

Valentina Studio

  • [Fix] 8259 High CPU usage with SSH tunnel after switch between different internet connections

Valentina DB

  • [New] db.Diagnose() now works in multi-thread way if logging of diagnosing disabled.

Valentina Server

  • [Chg] - Now Valentina Server always is MT version (improved multi-threading). We have removed separate archives of Server_MT.
  • [Fix] 8264 - broken processing of “BACKUP DATABASE”.

Release 8.3.1

2018-06-03

Valentina Studio

  • [New][Form Editor] - add 'records' property for form, subform and tableview.
  • [New][Form Editor] - add 'Reload Records' actions.
  • [New][Form Editor] - Automatically update TableView on change of the field it is linked to in the form.
  • [Imp][SQL Editor] - Show the connection and database selection controls above the Schema/Queries/Snippets tabs.
  • [Fix][Schema Editor] - sorting by size (e.g of Fields) in the Tree View.
  • [Fix][PostgreSQL] Don’t generate RETURN NULL statement in the function body automatically

Valentina DB

  • [Fix] 8267 - corruption of compressed Blob on ALTER TABLE.
  • [Fix] 8279 - EXPORT to TAB-separated text file now do not add BOM prefix to each line.

Valentina Server

  • [Fix] 8268 - in 64 bit installer fixed runtime dlls of visual. Was used 32 bit dlls.

Release 8.3.2

2018-06-10

Valentina Studio

  • [New][Form Editor] - The HyperLink control which opens a default browser window with the specified URL or executes a custom script.
  • [New][Form Editor] - The Image - Field control for displaying an image stored in the BLOB/Picture field or loaded by the URL stored in the textual field.
  • [Fix] 8281 - Excel dump result in more rows than the query result.

Valentina DB

  • [Fix] 8278 - ERR string is not readable.

Release 8.3.3

2018-06-27

Valentina Studio

  • [New] [FORM EDITOR] Added 'currentRow' and 'currentColumn' properties for the TableView
  • [New] [FORM EDITOR] Allowed to create QStringListModel from JS
  • [New] [FORM EDITOR] Allowed to change source records for forms/subforms/table views from scripts “this.records = this.dataSource.sqlSelect( …. )”
  • [New] [FORM EDITOR] Ability to use the query with parameters for the form.
  • [New] [FORM EDITOR] Added methods queryParameterValue/setQueryParameterValue to Form/SubForm/TableView
  • [New] [REPORT EDITOR] Ability to convert the controls to other types via the context menu. NOTE: for MySQL datasource, for example, it allows the users to transform the field control to the checkbox control.
  • [Fix] 8283 - Cannot connect to MS SQL through SSH tunnel.
  • [Fix] 8285 - JOIN is not generated for links created in the Query Editor in PostgreSQL database.
  • [Fix] [Query Editor] Fixed saving Query Editor own links for databases with schemas

Release 8.3.5

2018-07-07

Valentina Studio

  • [Imp][ValentinaDB] - The default value property of the ARRAY field now can be modified using the array editor (in the Create Table dialog and directly in the Schema Editor).
  • [Fix][ValentinaDB] - Fixed editing the ARRAY field values in the Data Editor.
  • [Fix][ValentinaDB] - Fixed generation of the default value definition of the ARRAY field.
  • [Imp][Form Editor] - Don't reset the source fields on change of the datasource, if possible.
  • [Fix][Form Editor] - Fixed crash on change of the datasource.
  • [Fix][Form Editor] - Fixed an access to the connection's parameters from JavaScript.
  • [Fix][Schema Snapshot] - Don't create the snapshot of the system schemas.
  • [Imp][Schema Snapshot] - PostgreSQL functions file names now include the input parameters type names, not their numeric IDs to be consistent between snapshots.

Valentina DB

  • [Fix] few issues about ARRAY field and its DEFAULT VALUE in the SQL.

Valentina Server

  • [Fix] 8298 - Crash on the creation of a new database with enabled privileges.

Valentina C ADK

  • [Fix] 8296 - Crash in Server_GetVariable()

Release 8.3.6

2018-07-17

Valentina Studio

  • [Imp][SchemaSnapshot] Create function snapshot with the schema in the filename, use type names of parameters in the comment to the function definition.
  • [Imp] German translation.
  • [Fix][Diagrams] Draw the links between tables in different schemas.
  • [Fix][Diagrams] Fix to show related tables in the list if they are located in different schemas.
  • [Fix][Diagrams] Ability to create a link between schemas
  • [Fix][PostgreSQL] Fixed link count for schema and table (links between schemas were not counted, also it fixed that these links were missing sometimes).

Valentina DB

  • [Fix] 8309 json_build_object() produce wrong result.
  • [Fix] 8313 Second parameter of TRIM function is not recognized in SQL statement
    • old function TRIM() renamed to BTRIM()

Release 8.3.7

2018-07-26

Valentina Studio

  • [Imp] Added new translations into RU and UA.
  • [Fix] 8311 Printing pie charts (on Windows).

Valentina DB

  • [Fix] 8310 json_extract_path() error
  • [Fix] 8317 CASE statement with ENUM values error
  • [Fix] 8318 “Simple” DateTrunc function

Valentina Server

  • [Fix] 8302 Database Events create bogus connections to a database which are subsequently blocking unregistering this database.

Valentina C++ SDK

  • [Chg][Win] - Now VSDK contains Valentina MT (“multi-threaded”) DLLs. They are located in the vcomponents_win_vc directory. If you want to use them you must specify them in your project.

Release 8.3.8

2018-08-08

Valentina Studio

  • [Fix] 8323[Data Editor] Right-click option “Set to NULL” not working.
  • [Fix] 8331 Fix showing “Add Related Tables” dialog for the table that was added to the diagram, removed and added again.
  • [Fix] 8332 Improve the rendering of the link lines in the Query Editor.
  • [Fix] 8333 Select-list items are swapped on dragging in the Query Editor, not inserted.
  • [Fix] 8334 Don't open the SQL Editor on double-click on the database when the Schema Editor is in Diagrams mode
  • [Fix] 8335 Ability to load the SQL dump into the connection.
  • [Fix] 8336[MySQL] Don't quote synonyms of CURRENT_TIMESTAMP default definition (for MariaDB).

Valentina DB

  • [Fix] 8322 COUNT_LINKED returns NULL value when used with SELECT INTO.
  • [Fix] 8325 ARRAY in stored procedures. Mostly fixed.

Release 8.3.9

2018-08-16

Valentina Studio

  • [Fix] 8281[SQL Editor] Excel dump result has more rows than the query result
  • [Fix] 8312 infinite loop when returning to a query whose results have been deleted.
  • [Fix] 8340[MySQL] Don't drop links in the dump if “Drop before restore” option is used (they dropped with tables)
  • [Fix] 8341[MySQL] Ability to split the records into few blocks for multi-row INSERT or transaction
  • [Fix] 8342[MySQL] Fix dumping default field values for the latest MariaDB servers
  • [Fix] [MySQL] Save dump options in the user prefs
  • [Fix] [MySQL] Add DROP DATABASE statement to dump if “Drop before restore” option is used
  • [Fix] [MySQL] Corrected mariadb version for proper quoting (https://mariadb.com/kb/en/library/information-schema-columns-table/)
  • [Fix] 8345[SQLite] shows columns which can't delete and which are invisible in other tools

Valentina for Xojo

  • [Fix] 8337 new property VDatabase.ActiveTable, to resolve rare cases.