Valentina Release 6.5.x Notes

(7 Apr 2016)

This release brings Valentina products to the ARM 32 LINUX Raspberry platform.

It is now possible to deploy Valentina Server on the ARM 32 Linux platform.

• Valentina Server including 3 major parts:
  • Valentina DB Server
  • Valentina SQLite Server
  • Valentina Report Server

It is now possible to deploy Valentina Reports Application Developer Kits on the ARM 32 Linux platform.

• Valentina C++ ADK
• Valentina for Java ADK
• Valentina for PHP ADK
• Valentina for Xojo ADK (Raspberry plugin included into each OS ADK)

Additional ADKs will become available in future releases.

It is now possible to deploy Valentina Database Application Developer Kits on the ARM 32 Linux platform.

• Valentina C++ ADK
• Valentina for Java ADK
• Valentina for PHP ADK
• Valentina for Xojo ADK (Raspberry plugin included into each OS ADK)

Additional ADKs will become available in future releases.

• [New][SQL DIFF] - Can generate now the reverse second db2 → db1 script, additionally to direct db1 → db2 script. Just specify check box to produce it.

(23 Apr 2016)

• [New] - Parameters of Report can now be recognized in the SQL Query String. This simplifies ADK code, because no need to build SQL string. Just specify values for parameters of the Report.

Read more: VReport Class: Methods

• [Imp] - SQLite updated to 3.12.1

• [Fix] 6886 - Add/Use SSL option on connect to MySQL server.
• [Fix] 7312 - Allow to clone Valentina Server database.
• [Fix] 7382 - Autocomplete has wrong sort.
• [Fix] 7435 - Optimization for Data Transfer.
• [Fix] 7594 - Database delete confirmation message should contain the name of the database.
• [Fix] 7603 - Vertical ruler in the Report Editor layout is rendered incorrectly
• [Fix] 7604 - TEXT field type few issues.
• [Fix] 7615 - Endless loop on “Replace All” action in SQL Editor if replacing text contains the searched text.
• [Fix] 7617 - Search behaves wrong for non-latin symbols
• [Fix] 7599 - Duplicate Object glitch.

• [Imp] - SQLite updated to 3.12.1

• [Fix] 4686 - Cloning a database clones into server directory, not databases directory.
• [Fix] 7598 - VServer hangs on wrong notification connection.
• [Fix] 7620 - Crash after clone of db.

• [Fix] 7587 - Diagnose results into Ram file.

• [Fix] - proceeding of exceptions.

(29 Apr 2016)

• [New] Report property 'ignore_pagination', which allows you 1) to print endless reports on paper 2) to produce “endless” HTML output.

• [New] - Connection dialog to VServer now have parameter: [x] Use Notifications.

• [Fix] 7581 - Modify Table Name Causes Column Comments To Disappear
• [Fix] 7628 - CSV import fails, if not all source fields mapped.
• [Fix] 7630 - MYSQL, In the dialog 'Create Table' changing the charset for a new column do not changes the list of collations.

• [New] - SNMP now can return port of SQLite.

(06 May 2016)

• [New] 7641 Add 'can_split' flag to allow the splitting of the region on the page breaks.
• [New] 7642 Add 'split_type' property for controls to allow start/stop splitting on the page breaks.

• [Wiki] Each control's wiki page updated to have description of these new properties.

• Note, that Report engine is included into Valentina Studio, Server and ADKs.

• Fix of bug introduced in 5.6.2 for PostgreSQL connection. Sorry.

• [New] 7644 Report Editor: Profiling option to show the reason for a region splitting. Prints the name of a control(controls), which doesn't fit at the end of the page and causes the region splitting.

(24 May 2016)

• [New] 7650 [SQL DIFF][WIZARD] Add flag 'auto close on done' to the last page
• [Imp] 7650 [SQL DIFF][WIZARD] Add flag 'auto close on done' to the last page

• [Fix] 7647 [POSTGRE] Changing the current value for Sequence leads to executing to many queries.
• [Fix] 7648 [MSSQL] There is no property CURRENT VALUE for Sequence.
• [Fix] 7649 Generate Query → Create for Sequence does not contain statement for current value.
• [Fix] 7652 If the CREATE TABLE statement contains BACKQUOTES around field names, they will be shown with these quotes in the schema editor.
• [Fix] 7664 Can't enter a 64 bit number into any table with a ULLONG field working with VServer.
• [Fix] 7665 Not showing SQL Server stored procedures properly.
• [New] 7674 Fix ability to connect to the named instance with dynamic port.
• [Fix] parse non-quoted unicode identifiers for SQLite.

• [Imp] 7659 Ability to get a result of SQL query using one HTTP request.

• [New][Example] How work with REST, yet from iOS.

(1 June 2016)

• [New][Report Editor] ReportHeader now have property 'before_page_header' to show report header before page header.

• [Imp] Updated to QT 5.6 on mac and windows. Linux still uses 5.5, because QT 5.6 have new bugs for linux. QT 5.6 fixes few glitches for Mac.

• [Fix][Mac] resize of tooltip
• [Fix][Max] slow drag and drop

• [New] 7666 Checking the SSL-Certificate via Code.

(16 June 2016)

• [New] 7675 Preference to disable the ability to resize text via the mouse.
• [Imp][MSSQL] Improved error handling.

• [Fix] 7678 SQL Server Bookmark for named instance shows as unavailable even if server is running.
• [Fix] 7682 Data Editor doesn't show all records in SQL Server 2005/2008 table.
• [Fix] 7686 The trigger's editor is missed in the Tree View.
• [Fix] 7692 Slowness on typing a new report name.
• [Fix] 7695 SQL Editor in the Result Grid get button 'Autosize' with choices how fit column size.
• [Fix] 7696 Format pattern wont work for double fields returned from ODBC DB (Firebird).
• [Fix] 7697 A new database creating with empty Locale Name.
• [Fix] 7699 Db is not opened if any Ram Db is opened in VStudio.

• [New] 7700 Db now has property 'ReadOnly' in SQL commands.
• [Fix] SQL command CREATE EVENT, now is more accurate with text of command after DO.

(6 July 2016)

• [Fix] 7696 Some improvements in SQL Query Editor for retina display. Still some glitches present because of reported QT bug.

• [Fix] 7645 Dump script for sequence does not restore the current value.

• [Imp] 7575 More info for “Valentina plugin have got string with UNDEFINED encoding”.

• [Fix] 7710 VConnection class needs SQL methods: SqlQuery(), SqlSelect(), SqlExecute().
• [Fix] 7714 Bind_Value processed incorrectly by Database_SqlSelect().

(27 July 2016)

• [Fix] 7719 CREATE OR REPLACE TRIGGER … drops existed trigger always even if new trigger contains semantic errors..

• [Fix] 7726 Group footer of subgroup is not always printed.

(16 Aug 2016)

• [New] Support MS SQL Azure.

• [Fix] Example Clone for client-server mode.

• [Fix] SQL dump load issue.

(26 Aug 2016)

• [Imp][Lin] There was problem if app linked to VKERNEL.so and VCLIENT.so, and user did Valentina_InitClient() only, but Strings work as kernel's ICU strings.

• [Fix] 7736 Inaccuracies with collations.
• [Fix] 7737 Unable to open a temporary (or RAM) table in the Data Editor.
• [Fix] 7739 VStudio replaces Preference Setting - instead of the “Show Methods” performs “Show OID”.

• [Imp][Diagrams] Fix to show editors area if it was hidden with splitter.
• [Imp][Diagrams] Added 'Close Others' menu item for editor tab.
• [Imp][VStudio] Added help menu item to get info about PRO features.

• [Fix] 7743 Issues if dump location passed to LoadDump doesn't exist.
• [Fix] 7745 Issue with VC_String. Problem was found via VSDK Example Class_BinaryLink in client-server mode.

• [Fix] 7746 auto_ptr replaced to unique_ptr, when compiled with cpp11.

(03 Sept 2016)

• [Imp] 7725 Implement auto reconnect if PostgreSQL connection is interrupted.
• [Imp] 7747 “Create Link” Improved to work with Valentina's DB Binary Link.
• [Imp] 7748 Restore last selected field type in the [CURRENT] Create Table dialog, reverted previous changes.

• [Fix] 7750 Renaming a Valentina link in the Property Inspector doesn't work.

• [Fix] 7754 DROP EVENT crashes.