Valentina Release 9.2.x Notes

2019-06-01

• [New][SQL Editor] You can now EDIT RESULT records of a VIEW query for PostgreSQL and MySQL.
  • ValentinaDB and SQLite already supported (MS SQL Server support not available at this time)

• [New][Form Editor] You can now EDIT records of a VIEW query for PostgreSQL and MySQL.
  • ValentinaDB and SQLite already supported (MS SQL Server support not available at this time)

• [Imp][Form Editor] Improved the HELP system of JS Editor

• [Imp][SSH] Updated SSH library to support modern digital signature algorithms (like ECDSA, EdDSA). Now it is possible to use ECDSA, ed25519 keys for connections to all supported database servers (Valentina Server, Valentina SQLite Server, MySQL, PostgreSQL, SQL Server).

• [Imp][SQL Editor][Pro] now works better with Table Aliases. Can recognize them correctly in sub-queries and use only in the valid scope.
• [Imp][SQL Editor] tooltip for table alias now works as for Table, shows the list of fields.

• [Fix][SQL Editor][PostgreSQL] tooltip for table now works.

• [Fix][8537] NOT NULL after REFERENCES in CREATE TABLE definition in SQLite interrupts reading the table structure

• [New] 'keep_together' flag for groups headers.

• [New][SNMP] allows getting the number of licenses for VDB/SQLite/Reports by SNMP.

• [New][8538]: “MERGE…ON…<multi-join-confitions>…WHEN NOT MATCHED” works now.

• [Imp] The speed of SQL parser improved in 1.5+ times.
  • Bench with 100K inserts into a table with 10 fields was 12 seconds, now 8 seconds. Changes only in the ANTLR parser.

2019-06-08

• [Fix]8548 - Crash in Forms on Execute.

2019-06-15

• [New][3 OS] Support of 7.3
• [New] Windows VPHP now has 64-bit archives.