Valentina Release 7.3.x Notes

2017-06-21

• [New][SQL Editor][PostgreSQL] - SQL Editor Result now can be updated in place! Double click a cell and edit it. This will create and send UPDATE command, also the result buffers will be updated.

• [New] - Import of diagrams from MySQL WorkBench. Use menu Diagram → Import.

• [Fix] 7978 - Can't export client cursor to CSV [VServer]“.
• [Fix] 7985 - DATETIME field value from SQL Server is not properly formatted.

• [Imp][SQLite] - updated to 3.19.3

• [Imp] - Improved work with barcodes.
• [New] - bar_width property for barcode
• [New] - Log error if barcode cannot fit area.

• VPHP Standalone now have ReportInit() method. We did use before only VPHP Client to Valentina Server. Since someone asked VPHP Standalone with Reports, we have add this feature.
• Report serials now can be stored into INI file, as for VPHP ValentinaDB serials.

2017-07-05

• [New][Report Editor] - Log the printer name and options passed to the PrintTo… Printer method. This can help you write your ADK code.
• [New][SQL Editor][MySQL] - MySQL users now also can do Update records of SQL Editor Result, as can PostgreSQL users from 7.3 version. See above.

• [Fix][Query Editor] 7986 - Fix missing controls position in some cases.
• [Fix][MySQL] 7994 - 'Format SQL' should not add SPACE between func name and '(' symbol for MySQL.

• [Fix][MySQL] 7987 - Lost connection with MySQL server error for bigger queries.
• [Fix] 8003 - Increase the default TEXT limit for MS SQL prefs from 4Kb to 64Kb, to avoid easy crop of Stored Procedures when they are displayed.
• [New] 8005 - Shows a new property 'Host OS' of Valentina Server 7.3.1 in the Property Inspector.
• [Fix][MySQL] 8015 - Don't start import process if the target table can't be created.

• [New] - Added 'PaperLength' and 'PaperWidth' printing options to set the custom size of the paper. Important for Windows.

• [New] 8001 - I_Field::get_OriginalFieldID(), I_Field::get_OriginalTableID(). Intended for fields of a cursor. Allows to find original table and field if this is possible. We use this in Valentina Studio to implement UPDATE of SQL Editor Result records. Only in C++ for now. TODO ADKs.

• [New] 8004 - Valentina Server properties: OS {“Windows”, “MacOS”, “UNIX”} and OSType {“32”, “64”}.
  • Use GET PROPERTY OS OF SERVER or SHOW PROPERTIES OF SERVER commands.

• [New] 7991 - I_SqliteCursor::get_ColumnOriginName() method. We use this in Valentina Studio. Only C++ for now. TODO ADKs.

2017-07-10

• [Fix] 7986 - Query Editor Position Not Saved.
• [Fix] 8012 - Mark the query as modified if layout is changed in the Query Editor.

• [Fix][Script Editor][Win] - relative paths for import command now work.

• [Fix][MySQL] 7976 - Fix warning on execution of the MySQL query with tunes information ON.
• [Fix][MySQL] 7983 - Add preferences “Data Grid”. Can't change SQL query results pane font.
• [Fix][MySQL] 8002 - Can't edit the MS SQL stored procedure text.

These methods added into VSDK, VCSDK, V4RB, VNET, VJAVA.

• [New][Method] VDatabase.TableByID(id) as VTable
• [New][Method] VField.OriginalTableID() as Int32
• [New][Method] VField.OriginalFieldID() as Int32

This method added into the same ADKs except V4RB. Calls the coressponded API method of SQLite.

• [New][Method] VSqliteCursor.ColumnOriginalName() as String

2017-07-11

• [New][SQLite] - SQLite users now also can UPDATE records in the Result of SQL Editor directly.

• [New] Local and Server Valentina DB now is able monitor queries and record times of their execution into special system table, if you ask for that. VDatabase object gets a new property IsMonitored to set this feature ON/OFF. Please use SQL command SET PROPERTY isMonitored OF DATABASE db1 TO 1

• [New] Adds property IsMonitored into Inspector for a Valentina DB.

2017-07-25

• [New][SQL Editor][All DB] - Ability to format *SELECTED* text in SQL editor. Up to now all text was formatted.
• [New][SQL Editor][ValentinaDB] - Valentina DB users now also can UPDATE records in the Result of SQL Editor directly.

• [New][SQL Editor][VDB] - Added Templates of SQL Command: MERGE.
• [Imp][SQL Editor] - Added side panel tabs tooltips.

• [Fix][MSSQL] 7963 - Error handling when connection is broken.
• [Fix][MSSQL] - Fixed saerch of LOCAL SQL Server instances.

• [Fix][ValentinaDB] 8022 - It is not possible to edit the table in the data editor, if the table contains ENUM fields with localized values.

• [Fix] 8026 - Fix CRLF line delimiter processing in the Import Wizard.
• [Fix] 8027 - Ability to set empty text qualifier for CSV import.
• [Fix] 8032 - Show completion progress in the Import Wizard based on the amount of data read from the file (all dbs except VDB).

• [New] - Add 'print_on_footer_pages' property for page footer/header.
• [New] - Allow to remove page footer/header from page with report's footer and data regions

• [New][Api] isMonitored property of VDatabase class added into V4RB, VNET, VJDK, VCSDK, VSDK. This is API analog of property added in v7.3.3 (see above).

• [New] 'fld_Sum_Time' field added into the table of system statistic.

• [Fix] 8025 - Fix VDB diagnose of table with the VARIANT field.

• [New] Method VCDK_Free() to free allocations that should be freed by user.