[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.
[Fix]
7978 - Can't export client cursor to CSV [VServer]”.
[Fix]
7985 - DATETIME field value from
SQL Server is not properly formatted.
[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.
[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]
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.
[Fix]
7986 - Query Editor Position Not Saved.
[Fix]
8012 - Mark the query as modified if layout is changed in the Query Editor.
[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][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][
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][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).
[Fix]
8025 - Fix VDB diagnose of table with the VARIANT field.
valentina/releases/7.0/7.3.txt · Last modified: 2017/07/26 17:17 by lynn