Switch to: V12V11V10V9V8V7V6V5

Valentina Release 7.3.x Notes

Release 7.3 Notes

2017-06-21

Valentina Studio Pro

  • [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.

Valentina Studio

  • [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

Valentina Reports

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

Valentina PHP

  • 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.

Release 7.3.1 Notes

2017-07-05

Valentina Studio Pro

  • [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.

Valentina Studio

  • [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.

Valentina Reports

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

ValentinaDB API

  • [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.

Release 7.3.2 Notes

2017-07-10

Valentina Studio Pro

  • [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.

Valentina Studio

  • [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.

Valentina DB ADK

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

Valentina SQLite API

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

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

Release 7.3.3 Notes

2017-07-11

Valentina Studio Pro

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

Valentina DB

  • [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

Valentina Studio

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

Release 7.3.4 Notes

2017-07-25

Valentina Studio Pro

  • [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.

Valentina Studio

  • [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).

Valentina Reports

  • [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

Valentina DB

  • [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.

Valentina C SDK

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