Softpedia >Windows >Internet >Servers >Database Utils >Valentina Studio >  Changelog

Valentina Studio Changelog

What's new in Valentina Studio 13.9.1

Mar 27, 2024
  • Valentina Studio:
  • This build continues to improve the 'Virtual Links' feature. We have added a manual way to create and Sync them via the Cloud.
  • [New][Pro] - ability to define 'Virtual Links' using dialog.
  • [New] - You can find the command 'Create Virtual Link' in the contextual menu for a Database and a Table.
  • [New][Wiki] - Section about Manual Virtual Links
  • [Free] In the Free Edition of Valentina Studio you can create up to 5 Virtual Links.
  • [New][Sync] - Virtual Links for a database, now are synced via Cloud, if you have turned on this feature in your Prefs Dialog.
  • [New][Sync] - New button with Cloud icon in the Main ToolBar to Expose the state of your Cloud Sync settings.
  • Click it to open Prefs Dialog of Valentina Studio at 'Sync Preferences' page
  • [Fix][ODBC] - Fixed an issue retrieving data with NULL values occurring with ODBC Drivers that don't support scrollable cursors (e.g., MS Access). It affected the correctness of the Data Transfer functionality.
  • [Fix][MSSQL] - Fixed the issue of displaying a list of databases when the user connecting to the server lacked permissions to access backup information. Now, the backup information is retrieved using a separate query.
  • [Fix][Data Editor] - Fixed an error that occurred after adding a new record to MySQL and MSSQL tables on Windows.
  • Valentina for Java ADK:
  • [Fix] - FIXED critical crash. Please upgrade your installation of this ADK if you use it.
  • Valentina for Xojo ADK:
  • [Fix] Supported building iOS projects for Simulator on ARM-based Mac systems.

New in Valentina Studio 13.8.1 (Feb 7, 2024)

  • Valentina Studio:
  • [New][Data Editor] - 'Foreign Key Value Editor' now has the layout switching menu.
  • [Imp][SQL Editor] - Move “Use Parameters” checkbox to the top of the right panel.
  • [Imp][DataEditor] - New Tooltip over ForeignKey cell.
  • [Imp][DataEditor] - New Tooltip over ForeignKey column.
  • [Fix][SQLite] - Fixed showing/editing Boolean values
  • Valentina PHP:
  • [Imp] PHP 8.3 support added.
  • Valentina DB:
  • [New] - new SQL functions. Related to 9314.
  • currValGlobal(),
  • currDoubleValGlobal()
  • currStringValGlobal()
  • currDateValGlobal()
  • currTimeValGlobal()
  • currDateTimeValGlobal()
  • Valentina Server:
  • [Fix]9314 - There is no way to get “global” current sequence value under vServer

New in Valentina Studio 13.8 (Jan 23, 2024)

  • Valentina Studio:
  • [New][Data Editor] - new feature: Foreign Key Value Editor
  • A window to select a Primary Key value for a Foreign Key cell.
  • Open a popup using CMD+click or a button below the edited cell.
  • Open this dialog as a modal window using double-click or the content editor button below the table view.
  • It works for ObjectPtr in Valentina DB also.
  • Wiki - Foreign Key Value Editor
  • [Fix] - switching to SchemaEditor and selecting the new database created/opened on the Start Page.
  • [Fix]9309[SQL ANALYZER] query with SELECT and 2 or more more sub-SELECTs deeper.
  • Valentina DB:
  • [Imp]9310 - Create db for already opened db now throws an error.
  • [Imp]9304 - Query too slow, so optimization made.

New in Valentina Studio 13.7.1 (Jan 2, 2024)

  • [Imp][Prefs][Data Editor] - Add 'Colorize Values' setting to disable colors in the Data Editor.
  • [Imp][Wizard][Create Dump] - Add button tooltip, replaced “Continue” with “Run”.
  • [Imp][Wizard][Load Dump] - replaced “Continue” with “Run”.
  • [Imp][Wizard][Export Text] - Auto-generate destination file name, replaced “Continue” with “Run”.
  • [Imp][Schema Editor][Valentina DB] - Added “Register Database”, “Upload Database”, “Register Project”, and “Upload Project” to database and project lists on a VServer in the Schema Editor.
  • [Fix][Data Editor][Valentina] - Fixed the update of the related panel after linking
  • [Fix][SQL Editor][Valentina] - Fix to use the correct template for all “Insert Record” commands.
  • [Fix][SQL Editor] - Fix collect identifiers with 'StartsWith' autocompletion mode.
  • [Fix][PostgreSQL] - Fixed the connection over SSL on Windows.

New in Valentina Studio 13.6 (Nov 28, 2023)

  • Valentina Reports:
  • [New] - PYTHON added (!) to Valentina Reports, additionally to JavaScript and SQL.
  • Can be used to write source queries for reports
  • Can be used for expressions in reports
  • [New] - A source query written using Python returns data for the report in one of three forms:
  • Cursor – a cursor returned by the datasource
  • Dictionary – a dictionary containing one row of data
  • Sequence – a list of dictionaries containing a set of rows of data
  • Valentina KERNEL:
  • [Imp][SQLite] Allow to use URI on create/open SQLite databases, for SQLite engine inside of VKERNEL.DLL
  • Valentina Studio:
  • [Imp][SQL Editor] - Enable 'Execute Current' even for single statement.
  • [Imp][SQL Editor] - Fix restore selection after 'Execute Current'.
  • [Imp][SQL Editor] - Disable auto repeat for 'Execute' actions.
  • [Imp][Schema Editor] - Add 'Refresh' action to 'schema lists' menu.
  • [Imp][Schema Editor] - Update the current list (in the tree mode) on refresh of a TAB-panel.
  • [Imp][Schema Editor] - Added 'Generate Docs' action in the contextual menu of Database object to all supported databases (MSSQL, MYSQL, PostgreSQL, SQLite).
  • [Note] - for ValentinaDB it was added in the 13.5.3 build.
  • [Imp][Project] - Don't run start script on restoring state at app start.
  • [Imp][MONGODB PLUGIN] - Restore tabs with collection/view editors.
  • [Fix]9253 - Database view loses keyboard cell focus when scroll wheel when you mouseover another view.
  • [Fix]9273 - Document not shown if added to an empty MongoDB collection in the Columns mode.
  • [Fix]9276 - Server Admin, Popup error message not hidden.
  • Valentina Report Server:
  • [New] - PYTHON added (!) to Valentina Reports, additionally to JavaScript and SQL.

New in Valentina Studio 13.5.3 (Nov 27, 2023)

  • SCHEMA EDITOR: Fix use all width in toolbar for buttons.

New in Valentina Studio 13.5.2 (Nov 20, 2023)

  • Valentina Studio:
  • [Imp][Main Menu] - Documentation Generator added to the 'Tools' menu.
  • [Imp][Schema Editor] - Documentation Generator now can be called easy from the contextual menu of a Valentina DB in Schema Editor.
  • TODO - other databases going to get this in the next release.
  • [Fix]9281 - Update field value not correctly updates field
  • Valentina Xojo:
  • [Fix][Win32] issue on Windows 32.

New in Valentina Studio 13.5 (Oct 10, 2023)

  • Valentina Reports:
  • [New] Reports for MongoDB. The source query can be defined in one of the following forms (controlled by the Language option of the query):
  • JSON – using commands which return a result set, e.g. { “find”:“collection_name” }
  • "find": "test"
  • JavaScript – retrieve data using JavaScript code. This approach is analogous to JavaScript-based queries for SQL data sources; only the API differs.
  • db.collection('test')
  • [New] Source query can be defined using JavaScript code. This allows JavaScript to build a set of data and produce a report. To do it, switch the Language option of the query to JavaScript. The code should return data in one of the following forms:
  • Array of objects where each object represents a row:
  • let data = [ { "Column1": "Value11", "Column2": "Value21" },{ "Column1": "Value12", "Column2": "Value22" } ];
  • Single object, just one row:
  • let data = { "Column1": "Value11", "Column2": "Value2" };
  • Cursor returned by the datasource after execution of an arbitrary query:
  • let data = datasource.sqlSelect("SELECT 1 AS Column1, 2 AS Column2, 3 AS Column3");
  • [New] Content of text controls (text field, expression field, label) can be printed on multiple pages if it doesn't fit on one page. This behavior is controlled by the following options of the spllit_type property:
  • Allow Split By Line – Long text can be split after any line of the text.
  • Allow Split By Paragraph – Long text can be split after the new line character.
  • [Wiki] Executing MongoDB Commands in the Valentina Studio in JSON and JavaScript forms.
  • [Wiki] MongoDB extension of Valentina Reports JavaScript API. New API can be used in scripts and JavaScript-based source queries.
  • [Wiki] Step-by-step tutorial describing the creation of the simplest report based on data coming from MongoDB datasource.
  • Valentina DB:
  • [New] Deterministic levels for UDFs. deterministic_characteristic
  • [Imp] Few internal improvements for better performance - using more std containers, algorithms instead of own solutions, String class improvements.
  • [Fix]9237 - Crash in SHOW command with tricky db-name.
  • [Fix]9240 - Comparing the result of the LEFT function using '=' operator is wrong.
  • [Fix]9242 - UDF's args behave like IO instead of IN.
  • [Fix]9245 - “Unexpected Exception on Reindex of : field_name” - Add table name to log message.
  • [Fix]9247 - SQL Diagnose node always creates a file with diagnose report.
  • [Fix]9249 - SQL Diagnose should produce an additional boolean field for diagnose result.
  • Valentina Studio:
  • [New][Report Editor] provide GUI to work with MongoDB datasource via JSON and JS.
  • [New][SQL Editor] - Now it can work with MongoDB using JavaScript. Before only JSON was available.
  • Yes, future we will rename 'SQL Editor' to 'Query Editor'.
  • [New] - Database Documentation Generator.
  • A special project which produces a report with a description of all major DB objects.
  • Based on Valentina Reports
  • Works for ValentinaDB, SQLite, MySQL, PostgreSQL, MS SQL.
  • [FREE] version users can adjust the datasource and generate predefined reports without modifications.
  • [PRO] owners can tune .vsp project to their needs
  • [WIKI] - Database Documentation Project
  • [Fix][MySQL] Skip adding precision and scale to SQL definition of the floating point type fields if unnecessary.
  • [Imp][PostgreSQL] Now the Data Editor filter is case-insensitive by default (similar to other engines).
  • Valentina Report ADKs [ALL]:
  • [New] - Reports for MongoDB
  • Valentina Report Server:
  • [New] - Reports for MongoDB
  • Valentina for Xojo:
  • [Imp] Added VDatabase.JournalFolder property. It can be useful for applications distributed via the Mac App Store. macOS may not allow the creation of the journal file near the database file, so it can be created, for example, in the Application Support folder.

New in Valentina Studio 13.3.3 (Jun 22, 2023)

  • Valentina Studio:
  • [Fix]9229 - Duplication of the subreport column header (preceding control has size_type=Relative To Region option).
  • [Fix]9231[SQLite] - Can't open SQLite databases via Open Database.
  • [Fix][PostgreSQL][Data Editor] - Fix showing NULL values for the timestamp in Data Editor.
  • [Fix][PostgreSQL][Data Editor] - Fixed refresh of links and functions.

New in Valentina Studio 13.3.1 (Jun 12, 2023)

  • Valentina Studio:
  • [Imp] More Tips added.
  • [Fix][Report Editor] - Fixed setting font size = 12 pt from the report editor toolbar.
  • [Imp][Data Editor]9221 - Button REFRESH in the main toolbar now re-apply filter if it was applied before.
  • [Fix][Data Editor]9218 - VStudio-DataEditor-FilterRow: Entered values of active filter are not visible after leaving the cell
  • [Imp][Sql Editor] - 'Default Schemas' menu choices now is saved to prefs and restored on the next start of VStudio.
  • [Imp][Sql Editor] - Implemented background async re-loading of idents when needed.
  • [Imp][Sql Editor] - Autocompletion - TAB-key did work wrongly if applied to a “<Smart Suggestion>” item. Now it works correctly, as ENTER-key.
  • [Imp][Sql Editor] - Autocompletion - ESC pressing now refreshes wrong idents. This fixes a very rare issue.
  • [Imp][Sql Editor] - IdentResolver - now recognise Valentina Report parameters $P() and $P!(), to not underline them as 2 wrong idents.
  • [Imp][Sql Editor] - IdentResolver - PostgreSQL-style of type-casting 'ident::type' now is recognised. Affects PostgreSQL and ValentinaDB.
  • [Fix][Sql Editor] - IdentResolver - is refreshed on changes in the 'Default Schemas' menu.
  • [Fix][Sql Editor] - IdentResolver - for databases with schemas - the query of type SELECT schema.funcName()

New in Valentina Studio 13.2 (Apr 19, 2023)

  • New WIN ARM64:
  • As applicable, Paradigma Software products are becoming available on the Win ARM64 platform. This release introduces the first products for WIN ARM64.
  • VSERVER
  • VSDK
  • VCSDK
  • Paradigma Software product licensing does not require a separate license for new hardware platforms. For this reason, a Valentina Server for Windows license will work on either x86 or ARM64.
  • Valentina Studio
  • [Imp][Schema Editor] - Format the size in Property Inspector, using Kb, Mb, Gb, …
  • [Fix][Report Editor] - Don't restore “internal” properties from the cache (fixes crash on generating a report).
  • Valentina KERNEL:
  • [Imp]9194 - File locking improvements.
  • Valentina for Xojo:
  • [New][ARM64] - plugin now contains DLL for WIN ARM64.

New in Valentina Studio 13.0.3 (Mar 5, 2023)

  • Valentina Studio:
  • [Imp] - Dark theme has got many new icons.
  • [Fix] - crash during CSV import.
  • [Fix] - On Adding of new bookmark could be a glitch
  • [Fix][Data Editor] - work of row-filter.
  • [Fix]9183 - Hangs when reloading SQLite tables

New in Valentina Studio 12.7 (Jan 24, 2023)

  • Valentina Studio:
  • [New][SQL Editor][MSSQL] - Now it is possible to edit the result records.
  • [New][Prefs][MSSQL] - Added NO_BROWSETABLE option to the preferences.
  • [New] - Show warning if a cursor is Read-Only with a hint on how to make it writable (add FOR BROWSE or set NO_BROWSETABLE option).
  • [Chg] - Extract the 'Diagram Editor' as a separate top-level tool from the 'Scheme Editor'.
  • icon 'Digram Editor' added to the toolbar.
  • [Imp][Dump Wizard] - Fixed showing dump progress for tables with more than 2^31 records.
  • Valentina for PHP:
  • [Imp] - Added support of PHP 8.2 for Linux and Windows.

New in Valentina Studio 12.6.2 (Jan 9, 2023)

  • Valentina Studio:
  • [New][Schema Editor] - Properties and other data are fetched in a separate thread(s).
  • This improves the responsiveness of GUI while you e.g. iterate Tables of remote DB Server.
  • In the status bar you can see for a short time the progress bar showing the execution of the task “Fetch properties of 'table'”:
  • [Fix]9164[SQL Editor][Mac] - Trackpad was not very responsive with option 'Wrap text' enabled.
  • [Fix][Forms] - Fix saving the current splitter position/current pane for forms.
  • [Fix][Query Editor] - Fix showing field names of a PostgreSQL view.

New in Valentina Studio 12.6.1 (Dec 23, 2022)

  • Valentina Studio:
  • [Imp] - SQLite updated to 3.40.0
  • [Imp][SQL Editor] - 'Cancel' button for SQLite and MongoDB.
  • [Imp][SQL Editor] - Show 'Cancel' button only after one second (to avoid flickering on execute fast queries)
  • [Imp][SQL Editor] - Highlight syntax in multiline dollar-string literals.
  • [Imp][SQL Editor] - 'Escape' key now closes console (if shown)
  • [Fix]5104 - Restore columns width on add/delete fields.
  • [Fix]5293 - Apply field's custom color on show column in DataEditor.
  • [Fix]5909 - Need ability to close editors with text field by keyboard shortcut - allow to use Ctrl-Enter to close dialogs.
  • [Fix]8174 - Window tabs cannot be torn off/float.
  • [Fix]8808 - Can't clone library.
  • [Fix]8245 - Indexes on function do not show up in the Table Indexes section with SQLite files.
  • Valentina DB:
  • [Imp] - Improve Posix error messages.
  • [Fix]7798 - Creating Boolean column ignores default value.
  • [Fix]8992 - Diagnose always throws exception for hash indexes.
  • [Fix]9159 - The last statement may not be finished with semicolon.
  • Valentina for PHP:
  • [Imp] - support PHP 8.2 on macOS.

New in Valentina Studio 12.6.0 (Dec 9, 2022)

  • Valentina Studio:
  • [Fix][Reports] - Remove useless whitespace on wrapping a text.
  • [Fix]9152[Reports] - Fix wrapping of long text without punctuation and spaces.
  • [Fix]9154[Reports] - Rename property 'lines_interval' to 'leading'.
  • [Fix]9151 - Design Table window does not display field names sometimes.
  • [Fix]9157[VCLIENT PLUGIN] - Incorrect/different date separators in SHOW EVENTS.
  • [Fix] - hopefully, crash around TreeItem::DeleteChildren, mostly for Linux.
  • Valentina DB:
  • [Fix]9144 - Error message “Dynamic SQL error” when flushing.
  • [Fix]9155 - Invalid text of view in 'SHOW TABLES'.
  • [Fix]9158 - Make YYYY-MM-DD date format suitable regardless of the current DTFormat
  • Valentina Server:
  • [New]3761 - add new setting in ini file – SPLITLOGFILE
  • Valentina Client:
  • (affects all ADKs and VStudio when used as VClient to VServer)
  • [Imp] - Fix error message for throwing error from vClient without connection.
  • [Fix]8421 - VException 626688 “Unknown”

New in Valentina Studio 12.5.10 (Dec 7, 2022)

  • Valentina Studio:
  • [Fix][Reports] - Remove useless whitespace on wrapping a text.
  • [Fix]9152[Reports] - Fix wrapping of long text without punctuation and spaces.
  • [Fix]9154[Reports] - Rename property 'lines_interval' to 'leading'.
  • [Fix]9151 - Design Table window does not display field names sometimes.
  • [Fix]9157[VCLIENT PLUGIN] - Incorrect/different date separators in SHOW EVENTS.
  • [Fix] - hopefully, crash around TreeItem::DeleteChildren, mostly for Linux.

New in Valentina Studio 12.5.9 (Nov 4, 2022)

  • [Fix][SQL Editor] - Tip for a sequence name.
  • [Imp][SQL Editor] - Static Analyzer:
  • Respects 'CREATE DOMAIN', 'DROP DOMAIN' commands.
  • Respects 'CREATE SEQUENCE', 'DROP SEQUENCE' commands.
  • SELECT tblAlias.fldName fldAlias
  • SELECT foo() fldAlias
  • [Imp][SQL Editor] - Ident Resolver:
  • DROP commands respect now the [IF EXISTS] clause.
  • [Imp][SQL Editor] - Autocompletion:
  • More names of DB objects extracted now from the supported DBMS.
  • For example: TYPE in VDB, UNIQUE in SQLite, etc.

New in Valentina Studio 12.5.8 (Oct 15, 2022)

  • Valentina Studio:
  • [Imp] stability in a few places (most for MySQL).
  • [Imp][PostgreSQL] - Updated client and dump utilities to version 15.
  • [Imp][SQL Editor]
  • [Imp] IndetResolver now works for most ALTER and DROP commands.
  • [Imp] Autocomplete for CALL command.
  • Valentina DB:
  • [Fix]9144 - Error message “Dynamic SQL error” when flushing

New in Valentina Studio 12.5.7 (Oct 6, 2022)

  • Valentina Studio:
  • [Imp][MSSQL] - Updated Compatibility Level database property - added newer server versions, including 2022.
  • [Imp] - Improved crash dumps, which VStudio sends to Paradigma in case of a crash.
  • Valentina DB Server:
  • [Fix]9133[Mac] - Can't open log files of vserver (permissions). Returned to previous logic.
  • Valentina DB:
  • [Fix]9113 - Testing Boolean fields with IS TRUE/IS NOT TRUE produces an empty result.
  • [Fix]9145 - Setting numeric collation results in tertiary strength for field.

New in Valentina Studio 12.5.5 (Sep 8, 2022)

  • [Imp][MySQL] - Add 'Aria' to list of engines (default engine for system tables in MariaDB).
  • [Imp][MYSQL] - Add new keywords from MariaDB.
  • [Fix][MySQL] - Fix update Charset/Collation properties of connection
  • [Fix][MSSQL]8494 - Enabled Schema and Start input fields in MS SQL Create Sequence dialog
  • [Fix][MSSQL]9134 - Fixed wrong display of MSSQL Sequence properties Start, Min Value, Max Value
  • [Fix][SQL Editor][MSSQL] - Fixed showing values of SQL_Variant fields in the SQL result

New in Valentina Studio 12.5.3 (Aug 18, 2022)

  • Valentina Studio:
  • [Fix][Data Editor] Fixed crash on editing a cell with the right border off the screen.
  • [Fix][MySQL] - Fixed creating and dumping a table with auto-incremented indexed field (non-PK, non-Unique).
  • [Fix]9128: Disabling Zoom only disables magnification.
  • Valentina for Xojo (V4RB):
  • [Fix] build script broken for 12.5.2 after our internal optimizations in CD/CI, as the result ARM was lost in V4RB vcomponents, now it is back.
  • Valentina for Python ADK:
  • [Imp][Mac] - now compiled with ARM option.

New in Valentina Studio 12.5.2 (Aug 12, 2022)

  • Valentina Client:
  • [Upd] - OpenSSL updated to 1.1.1q (and some related libraries)
  • [Imp][Mac] - compiled with ARM flags
  • Valentina Studio:
  • [Upd][Mac][MSSQL] - Updated FreeTDS to 1.3.12
  • [Imp] - German translation.
  • [Fix][Mac][Arm] - now works connection to MSSQL Azure.
  • [Fix][SQL Editor] - crash on the editing of a literal with e.g Cyrillic chars.

New in Valentina Studio 12.5.1 (Aug 5, 2022)

  • Valentina Studio:
  • [Fix][Mac] crash on the internal assert of Qt.
  • [Fix]9118 - Fix filtering by Date/Time fields in the Data Editor
  • Valentina Server:
  • [Fix] possible deadlock found.
  • Valentina C SDK:
  • [Imp] - Added an ability to call Valentina_SetDebugLevel(0) before Valentina_Init() to avoid the creation of the log file

New in Valentina Studio 12.5 (Aug 1, 2022)

  • Valentina Studio
  • [Imp] - switch to Qt 6.3 on all OS.
  • [New][SQL Editor] - placeholders in SQL text when:
  • [New] - an auto-complete suggestion is inserted
  • [New] - auto-complete insert a built-in or User-Defined function with arguments as placeholders
  • [New] - a snippet is inserted
  • [New] - template of SQL command is inserted
  • [New] - Table → Generate SQL → INSERT: provides placeholders in the VALUE part.
  • [New][Wiki] placeholders page.
  • [New][DataEditor] – Filter cell now can contain a few values as a comma-separated list. This will be used as SQL search with “fld IN (value1, value2, …)”.
  • [Fix][Data Editor]7838 - Improve FILTER for Boolean fields:
  • Now 0/1 in filter-row are replaced with FALSE/TRUE for PostgreSQL
  • IS TRUE/IS NOT TRUE/IS FALSE/IS NOT FALSE filters are supported for all databases
  • [Fix][SQL Editor]7930 - SQL formatting is incorrect for comments where “–” is preceded by a character
  • [Fix][Query Editor]8217 - Update the generated query by clicking the “Select All” checkbox if some fields have already been selected.
  • [Fix][Schema Editor][SQLite]9105 - 'Default Value' during design Table
  • Valentina DB:
  • [Imp][BLOB]9119 - The speed of BLOB UPDATE will grow even more compared to improve in 12.4.4
  • Yet in 5-10* times
  • (!!!) CHANGES in db format for BLOB fields.
  • (!!!) Please backup your database BEFORE opening it in the 12.5, because conversion is automatic, and there is no back-conversion.
  • [Info] - we have swithed all our projects to C++20 standard.

New in Valentina Studio 12.4.4 (Jul 3, 2022)

  • Valentina Studio only hotfix:
  • [New][SQL Editor][PostgreSQL]9053 - Typing $$ adds another pair $$, to support dollar-quoted-literals of PostgreSQL.
  • [Imp][SQL Editor][PostgreSQL] - AutoComplete now respects dollar-quoted-literals.
  • [Imp][FORM EDITOR] - Allow to use numbers to modify QLineEdit.text property
  • Few fixes to improve stability

New in Valentina Studio 12.4.3 (Jun 25, 2022)

  • Valentina Studio only hotfix
  • few fixes to improve stabilit

New in Valentina Studio 12.4 (Jun 22, 2022)

  • Valentina Studio:
  • [Chg][SQL Editor] - Now 'tblAlias.FldName' items in the auto-complete menu can be used in a FREE Valentina Studio.
  • [New][SQL Editor][Pro] - New smart suggestions in the auto-complete menu for the UPDATE command when you typed 'SET'.
  • [Imp][SQL Editor] - More suggestions in the auto-complete menu for the INSERT command.
  • [Fix]9094 - Adding a new record does not consider an Unsigned toggle on a field in MySQL table.
  • Valentina DB:
  • [Imp][BLOB] - Re-write some algorithms for BLOB fields that can improve the speed of INSERT/UPDATE operations from 5 to even 100 times.
  • The bigger BLOB values - the bigger difference you may see
  • Especially for compressed BLOB values.
  • This changes only algorithms, no changes in format.
  • [ANN] - in the next major release 12.5, we will do one more step to improve BLOBs with a change to the format.
  • This step will improve the speed of BLOBs even more in the same magnitude.

New in Valentina Studio 12.3.6 (Jun 10, 2022)

  • [New][SQL Editor][Pro] - AUTO-REFRESH of schema if in SQL Editor was executed some DDL command (CREATE/DROP/ALTER).
  • [Free] - users of Free Valentina Studio, will see this feature 2 times per start, after that notification in the console of SQL Editor.
  • [Fix][SQL Editor] - crash in method 'SqlAutoCompleter::posInComments()'.

New in Valentina Studio 12.3.5 (Jun 6, 2022)

  • Valentina Studio:
  • [Fix][SQL Editor] - crash sometimes related to table alias in the query.

New in Valentina Studio 12.3.4 (Jun 3, 2022)

  • Valentina Studio:
  • [Imp][SQL Editor] - Few fixes and improvements around SQL AutoComplete when few commands present in editor.
  • [New][SQL EDitor] - Static Analyzer now is able show error for INSERT command, if the number of items in the FIELD-list and VALUE-list is not the same.

New in Valentina Studio 12.3.3 (May 24, 2022)

  • Valentina Studio:
  • [New][SQL Editor] - Many improvements in the work of AutoComplete for the INSERT command.
  • [Fix][Diagram Editor] - loading of diagrams on Linux.
  • [MySQL] Fix for adding records to tables with an estimated record count.

New in Valentina Studio 12.3.2 (May 9, 2022)

  • Valentina Studio:
  • [Fix][SQL Editor][All] Fixed rare crash in SqlIdentResolver::DefineIfTheFirstWordOfCmd() during typing, introduced in 12.3.1
  • [Fix][Data Editor]9064 - Error with TIME array - ERROR: function to_char(time without timezone[], unknown) does not exist
  • [Fix][Data Editor][PostgreSQL] - Fixed showing TIMESTAMPTZ field values in the related table
  • Valentina Reports:
  • [Fix]9090 - fixed bug of 12.3.1 after use of new XML library, could be corruption in vproject after upgrade to 12.3.1

New in Valentina Studio 12.3.1 (May 8, 2022)

  • Valentina Studio:
  • [New][SQL Editor][All] Autocomplete now is able to show the list of the second keywords after the first keyword is typed for such commands as 'CREATE TABLE', 'ALTER COLUMN', 'DROP CONSTRAINT' etc.
  • This feature works taking into account the SQL dialect of the current DB.
  • Valentina DB:
  • [Imp]3908 - Improved speed of BLOB update, when BLOBs are huge (dozens of MBs).
  • Valentina for Python ADK:
  • [New] Added report.localPrinters() and report.serverPrinters() methods to list available printers.
  • [Imp] Added an ability to pass a custom query to generate a report: project.report( reportName, datasourceString, query )

New in Valentina Studio 12.3 (Apr 29, 2022)

  • [New][SQL Editor][MySQL] - AutoComplete differ sys symbols from user symbols. Controlled by prefs.(This feature was implemented for other DBs already).
  • [Imp][SQL Editor] - AutoComplete now uses RegEx style for keywords and built-in functions.
  • [Imp][SQL Editor] - AutoComplete recognize now the first keyword of SQL command in all scenarios.
  • [Imp][SQL Editor] - AutoComplete tooltip on the first show now is able auto-update to display more info about symbol after is load from DB.
  • [Fix][FORM EDITOR]9084 - NULL values of a Date field are now shown correctly in the Form field.
  • [Fix] - Fix for saving diagrams with space in the name (allowed to use spaces in tags in XML parser). Was broken in 12.2.1

New in Valentina Studio 12.2.1 (Apr 19, 2022)

  • [Imp][Report Editor] - few optimisations when report contains subreports with big pictures.
  • [Imp][SQL Editor] - auto-completion menu show only possible keywords when you start typing the first word of a command.
  • [Imp][SQL Editor][MSSQL] - now differ system symbols for MSSQL also in auto-completion.
  • [Imp][Mac] - recognize new format .ips of crash logs to send to Paradigma Software.
  • [Fix] version in URL of menu HELP → wiki

New in Valentina Studio 12.1.1 (Mar 31, 2022)

  • Valentina Studio:
  • [New][Report Editor] Working with remote Valentina Report Server, to display a Report Preview with datasources connected via SSH with key authentication, Valentina Studio needs to send SSH keys to VServer.
  • Now VStudio is able to do this.
  • You need to use VServer of 12.1.1+ version also.
  • [Fix] Sorting of snippets, bookmarks. Was broken in 12.1.0
  • [Fix][MySQL] showing the charset list in Create Database dialog.
  • Valentina Server:
  • [New][Docker] Added ARM64 Docker image.
  • Valentina Server on Docker Hub
  • Valentina Server Docker Documentation
  • [New][Reports] Ability to accept automatically SSH private keys from Valentina Studio to build a Report Preview with datasources connected via SSH with key authentication. The keys are saved in the folder specified in SystemSSHkeysFolder option of the INI file.

New in Valentina Studio 12.1 (Mar 24, 2022)

  • General:
  • [New] Introduces ARM64 compiled for Linux.
  • Includes such products: VServer, VSDK, VPython, VJava, VPHP, VRuby.
  • Valentina Server:
  • [New] Folder to keep SSH keys. Read More ...
  • SystemSSHkeySFolder = SSH_Keys
  • Valentina Studio:
  • [New][SQL Editor]9063 Use Ctrl + 0 to reset zoom level of font.
  • [New][Server Admin] for ValentinaDB adds a new 'Server State' TAB-panel to see in LIVE mode tasks inside a Valentina Server.
  • [Imp][SQL Editor] Static analyzer now better works with [Schema.]Table for databases, which support Schema Names.

New in Valentina Studio 12.0.5 (Mar 10, 2022)

  • Valentina Server:
  • [New] - Each job for a client inside of VServer now is able to answer which SQL command it executes.
  • [New][C++] - I_VServer interface now has method virtual I_Cursor_Ptr GetState( void ); which returns cursor with 2 columns: “client-id” and “state”.
  • [New][V4RB] - also get analog method VServer.GetState() as VCursor.
  • [New][Wiki] - VServer.GetState() method description.
  • [Todo] - this feature will be used in Valentina Studio soon to display such states.
  • Valentina for Python:
  • [New] - method report.printToLocalPrinter
  • [New] - method report.printToServerPrinter

New in Valentina Studio 12.0.4 (Mar 8, 2022)

  • [New][MongoDB] - Added aggregation and query and write operation commands templates
  • [Imp][SQL Editor] - improve Auto-complete for special list 'ON KEY DUPLICATE UPDATE SET ',
  • [Fix][SQL Editor] - Fixed crash on SQL formatting on macOS (reverted recent change to formatting library)
  • [Fix][MSSQL] - fix connection to Azure for VStudio WIN.

New in Valentina Studio 12.0.2 (Mar 3, 2022)

  • Valentina Studio:
  • [New][SQL Editor] Autocomplete will display 'ON KEY DUPLICATE UPDATE SET' suggestion for command: INSERT … VALUES (…) ON
  • [New][MongoDB][Command Editor] - dozen TEMPLATEs of commands to MongoDB Server. Choose - click - run.

New in Valentina Studio 12.0.1 (Mar 3, 2022)

  • Valentina Studio:
  • [Fix][MongoDB] fix processing errors from the SORT option in Data Editor.
  • [Fix][MongoDB] detach views before 'drop database' operation.

New in Valentina Studio 12.0 (Feb 14, 2022)

  • Valentina Studio:
  • [New] MongoDB:
  • [New] MongoDB plugin - the first NON-SQL DB in Valentina Studio.
  • Schema Editor
  • Command Editor (similar to SQL Editor)
  • Collection Editor (Data editor)
  • Server Admin (manage users, databases, etc)
  • [New] Workspaces:
  • [New][Pro] Workspaces - this great feature for PRO-developers, which now get a clean isolated room for a project.
  • You can create a new workspace, which will collect Bookmarks, Recent databases, Recent SQL queries, SQL snippets, opened TAB panels (soon)
  • Switching between workspaces moves you to this or that project context.
  • [New] Menu 'Workspaces' in the main menu
  • [New] Top-Right button-menu workspaces to visualize the current workspace and manage workspaces.
  • Others:
  • [Imp][Start Page] - COPY/PASTE a single bookmark
  • [Imp][SQL Editor] - Tooltip of a snippet now shows database(s) to which it belongs.
  • [Imp][SQL Editor] - Tooltip about hidden snippets.
  • [Imp][Dialogs] - Dialogs to export bookmarks, snippets, etc, now suggest the default name of the file.
  • Valentina DB:
  • [New][SQL] JOIN between 2 different databases.
  • [New][SQL] Triggers on Links.
  • This allows you to CREATE TRIGGER, which will work on LINK / UNLINK commands - events.

New in Valentina Studio 11.5.0 (Nov 28, 2021)

  • Valentina Studio:
  • [Fix][AutoComplete] skip showing auto-complete-menu if the typed token contains only digits.
  • [Fix][AutoComplete] [PostgreSQL] Fixed saving the list of default schemas to the schema cache.
  • [Imp] Overall internal improvements.
  • Valentina DB:
  • [Imp] Overall internal improvements.

New in Valentina Studio 11.4.8 (Nov 6, 2021)

  • Fix: Labels of EAN-13, UPC-A, UPC-B, ISBN barcodes are generated without the leading digit, GS1 DataBar label is cropped.

New in Valentina Studio 11.4.7 (Oct 26, 2021)

  • Valentina Studio:
  • [Imp] Updated PostgreSQL client library and dump utilities to version 14.
  • Valentina DB:
  • [Opt] improved Stmt.Select() for queries over 1 table and 1 unique field. Speed up x10 times.
  • [Opt] overall speed up of engine.
  • Valentina Python:
  • [Imp] Removed explicit linking to Python 3.7 dynamic library, any compatible version can be used now.

New in Valentina Studio 11.4.6 (Oct 3, 2021)

  • Valentina DB:
  • [Imp][Mac] internal algorithm to find vcomponent DLLs, to get it working e.g. in a Photoshop plugin, which uses ValentinaDB.
  • Valentina Reports:
  • [Imp] Don't limit barcode data length to 256 characters.
  • Valentina Python:
  • [New] prepare() in cursor, which returns function, which accept binding parameters.
  • This is analog of Stmt = db.Prepare( query ) in other languages

New in Valentina Studio 11.4.5 (Oct 3, 2021)

  • Valentina Studio:
  • [New][Data Editor] – Added currency formatting for float/double/decimal/money fields.
  • [New][PostgreSQL] – Implemented support of METHOD FIELDS (generated columns), which was added in PostgreSQL v12.
  • [New][PostgreSQL] – Implemented support of identity fields.
  • [Fix][MySQL]9014 – Fixed CSV import into MySQL table.
  • Valentina DB:
  • [Imp] – Improved speed of queries with WHERE, ORDER BY, and HAVING clauses if there is a compound index including target fields.

New in Valentina Studio 11.4.3 (Oct 3, 2021)

  • Valentina Studio:
  • [New][Data Editor][Pro] - Formatting of data of a column. Do right-mouse click on a column header to see the contextual menu, where you can find the “Format” command.
  • For example, for a column with Integer type, you will see Format { Decimal, Hexadecimal, Binary, Octal }.
  • You can also set a suffix to value, e.g. “mm”
  • For each supported DB was provided formats for their native types. For example, for PostgreSQL was made MacAddr, URL, Point, etc.
  • [Upd][MAS] - Apple AppeStore version of VStudio updated to 11.4.2

New in Valentina Studio 11.4.2 (Oct 3, 2021)

  • Valentina Studio:
  • [Imp][Diagram Editor] - Managing printing of diagram to pages.
  • Now you can specify the size of the page in mm INSTEAD OF the size of a diagram in pixels.
  • You can specify the number of pages by vertical and horizontal.
  • You can specify page margins
  • ValentinaDB:
  • [Opt] speed of UPSERT improved about 30%.
  • C++ SDK:
  • [New][Example] SqlStatement_Upsert, which is also a kind of a bench.

New in Valentina Studio 11.4.1 (Aug 9, 2021)

  • Valentina Studio:
  • [New][SQL Editor][Pro]9000 – Autocomplete now suggests all fields for “SELECT tblAlias.| FROM TBL tblAlis”
  • [New][SQL Editor]8999 – Autocomplete now respect command “CALL procName()”.
  • [New][PostgreSQL] – Show partitioned tables in the Schema Editor (for issue #8866)
  • [New][VDB]9001 – JSON field from Valentina DB integrated.
  • [Imp][SQL Editor] – Autocomplete now filters out symbols better in a SELECT command.
  • [Imp][SSH] – Added more detailed error messages for public-key authentication, with suggestions on how to fix them
  • [Fix][SSHManager] – removed active waiting for SSH (it reduced CPU utilization).
  • [Fix][SQL Editor][MySQL] – getting the list of built-in functions from hosts where MySQL system tables are unavailable due to restricted permissions.
  • [Fix][MySQL]8991 - Can't add row with value of YEAR type in MySQL database
  • Valentina Server
  • [Fix][Report Server][Linux] – Fixed issues on accessing VDB data sources in some cases.
  • Valentina Reports:
  • [Fix][Windows] – Fixed printing reports hosted on Valentina Server to a local printer from client applications on Windows (without Valentina.Init or Valentina.InitReports calls).
  • [Fix][Windows] – Fixed printing reports in reverse order.
  • Valentina DB:
  • [Imp][Linux] – Now it is not necessary to have aliases in vcomponents folder. Aliases could get lost during the transfer to hosting, now there is no need to recreate them which simplifies deployment.
  • Some fixes.

New in Valentina Studio 11.3.1 (Jul 2, 2021)

  • Valentina Studio:
  • [Fix]8983[Data Editor] – Enable filter button state while typing the filter text.
  • [Fix] Fixed dumping values to SQL for MySQL, SQLite, SQL Server and ODBC.
  • Valentina Server:
  • [Imp] More log errors on vServer start.
  • Valentina Reports:
  • [Fix] Fix remove the empty line for subreports in a group with empty pasted content

New in Valentina Studio 11.3 (Jun 24, 2021)

  • Valentina Studio:
  • [New][PostgreSQL] Value Editors for PostgreSQL, including Arrays.
  • [Imp][App] Restore geometry on the current screen (for all platforms).
  • [Imp][PostgreSQL] Show boolean field values as checkboxes in SQL Editor and form based on the query.
  • [Fix][Server Admin][PostgreSQL] Fix - enable Apply button on change of the role properties.
  • [Fix][Schema Editor] Fixed sync selection on the switch from the Columns to Tree.
  • [Fix][SQL Editor] Fixed crash in case if autocompletion is shown and tab is closed with CMD+W
  • [Fix]8978 - VStudio doesn't show the correct path for databases in Server Admin (VServer).
  • [Fix][DataEditor][Scripts] Don't ignore setting NULL field value for a new row if this field is nullable and the default is not NULL
  • Valentina for Xojo:
  • [Fix][Examples] few examples fixed after Xojo remove deprecated “.AbsolutePath”

New in Valentina Studio 11.2.5 (Apr 26, 2021)

  • [New][MSSQL] Specialized Data Editors for MS SQL.
  • [Fix][Schema Editor] Fixed delay after applying the schema changes – don't wait for internal tasks to finish.
  • [Fix][SQL Editor] Fixed positioning the autocompletion menu on the secondary display.
  • [Fix][Data Editor] 8887 Fixed error when loading related PostgreSQL table which has a JSON column.
  • [Fix][Data Editor] 8948 Fixed showing NULL values in the table data.
  • [Fix][PostgreSQL] 8942 Fixed generation of the query to create an index – supported INCLUDE clause.
  • [Fix][VDB] Fixed restoring date and time separators in local prefs.
  • [Fix][MySQL]
  • Fixed reading NULL default values in the column definition.
  • Fixed showing NULL values in result of the query.
  • Restored “Float” field type, removed “Real”.
  • Valentina DB:
  • [New][SQL] now works SQL command 'UNLINK RECORDS (1,..) FROM EACH RECORD' or 'UNLINK RECORDS (1,..) FROM ALL RECORDS'.
  • [Fix] Critical bug for page files with millions of pages. The update is recommended for users with potentially big Tables/Links/Indexes (hundreds of millions of records).
  • Valentina for Xojo:
  • [Imp] Updated macOS deployment script – added an ability to specify individual vcomponent libraries to copy to the app (kernel, vclient, report)
  • [Imp] deployment scripts added into the installer of V4RB
  • So you can easily call from a command line, OR use from a Xojo post-build script.

New in Valentina Studio 11.2.4 (Apr 14, 2021)

  • [New][Data Editor] Now the value editor can be shown in the popup below the edited cell.
  • [New][Data Editor] Added date&time editors (Valentina and MySQL only)
  • [New][Data Editor] Added JSON editor. If JSON content is detected in the text, the editor shows JSON data in two tabs – as a tree and as a highlighted text.
  • [New][Data Editor] Added HTML editor. If HTML content is detected in the value, the editor shows HTML data in two tabs – in a visual editor and in a source editor with highlighting.
  • [New][Data Editor] Added highlighting for cells with JSON content.
  • [New][Data Editor] Added highlighting for cells with HTML content.
  • [Imp][Data Editor] Picture editor now has auto-scaling and drag&drop.
  • [Fix]8923 - SQL dump creates a file that Dump loading will find not valid and create errors.
  • [Fix]8927 - Fix connection to Azure SQL databases.
  • [Fix] - [MySQL][SQL Editor] Don't highlight all words as keywords for the latest versions of the MySQL server.

New in Valentina Studio 11.2.2 (Apr 7, 2021)

  • Valentina Studio:
  • [Fix][Data Editor] - fix detect JSON for blob preview, optimization
  • [Fix][SQLite] - Add brackets if the field DEFAULT value is an expression. Fixes DateTime('now') default.
  • Valentina DB:
  • [Fix]8933 - diagnose improvements. The source of the issue is a UTF16BE storage encoding. Now Diagnose also prints info about encoding.

New in Valentina Studio 11.2.1 (Apr 7, 2021)

  • Valentina Studio:
  • [New][Data Editor] Added an ability to set a text alignment for cells in the grid.
  • [Fix]8936 – NULL value fields shown as empty (PostgreSQL)

New in Valentina Studio 11.2 (Mar 25, 2021)

  • [New][Data Editor] Now the value editor can be shown in the popup below the edited cell.
  • [New][Data Editor] Added date&time editors (Valentina and MySQL only)
  • [New][Data Editor] Added JSON editor. If JSON content is detected in the text, the editor shows JSON data in two tabs – as a tree and as a highlighted text.
  • [New][Data Editor] Added HTML editor. If HTML content is detected in the value, the editor shows HTML data in two tabs – in a visual editor and in a source editor with highlighting.
  • [New][Data Editor] Added highlighting for cells with JSON content.
  • [New][Data Editor] Added highlighting for cells with HTML content.
  • [Imp][Data Editor] Picture editor now has auto scaling and drag&drop.
  • [Fix]8923 - SQL dump creates a file that Dump loading will find not valid and create errors.
  • [Fix]8927 - Fix connection to Azure SQL databases.
  • [Fix] - [MySQL][SQL Editor] Don't highlight all words as keywords for the latest versions of MySQL server.
  • [Fix]8932 - Client idle timeout might be ignored in some cases.

New in Valentina Studio 11.1 (Feb 28, 2021)

  • ALL:
  • [Imp] SQLite engine updated to 3.34.1
  • Valentina Studio:
  • [Fix][MSSQL] Rebuilt FreeTDS to fix failed connection
  • Valentina for Xojo:
  • The Xojo development environment supports multiple compile targets, including macOS, Windows, Linux, iOS and more. You can find the iOS example projects within the downloadable archive.
  • [New] iOS plugin, which supports Valentina Client, i.e.
  • Valentina DB Client to Valentina Server
  • Valentina SQLite Client to Valentina Server
  • Valentina Report Client to Valentina Server
  • [New][iOS] Examples:
  • API_way/Field_CreateDrop
  • RBDB_way/SqliteExampleModified
  • SQL_Way/Field_CreateDrop
  • VReport/ReportOnSQLite
  • VReport/ReportOnValentina

New in Valentina Studio 11.0 (Feb 17, 2021)

  • Valentina Studio:
  • [New][VStudio] Pass parameters when previewing report in browser if HTTP port of VServer is enabled.
  • [Fix][SQLDiff] Fixed creation of SQLDiff parameters for SQLite client databases.
  • [Fix][Schema Editor] Fixed creation of field for new ObjectPtr link.
  • [Imp][Schema Editor] Close Valentina project and database automatically before unregistering.
  • Valentina Server:
  • [New]8913 - Set binding to the report's query for vServer's HTTP.
  • [Fix]8918 - Add “datasource” param to the HTTP server to generate reports from any supported database.
  • [Fix]8911 - USE command should produce more clear error when the target database is closed.
  • Valentina Reports:
  • [Fix] Fixed printing pictures from SQLite datasources.
  • [Fix] Use ?N format of SQLite bind parameters.

New in Valentina Studio 10.6.3 (Jan 25, 2021)

  • NOW SUPPORTS POSTGRESQL 13!
  • [Fix] CRASH in Auto-Completer, when typed ON in the JOIN clause, and 1 or 2 tables mentioned in the FROM clause are missing.
  • [New][SQLite] Supported SQLite generated columns (also known as methods, calculated fields) in:
  • Schema Editor
  • Diagram Editor
  • Query Editor
  • SQL Editor
  • SQLDiff

New in Valentina Studio 10.6.1 (Dec 16, 2020)

  • [Imp] Autocomplete of JOIN for ValentinaDB BinaryLink works now.
  • [Fix] Couple fixes in autocomplete
  • [New][Query Editor] Added dialog to edit JOIN. It it used to:
  • change kind of JOIN – INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN;
  • swap tables – switch between, e.g T1 LEFT JOIN T2 and T2 LEFT JOIN T1
  • modify the joined fields.
  • [Fix][Preferences] Fixed wrong minimum size of the preferences dialog.

New in Valentina Studio 10.6 (Dec 7, 2020)

  • [New][SQL Editor][Pro] Autocomplete menu now suggets JOIN conditions
  • [New][SQL Editor] Autocomplete menu now has a bottom line where help is printed.
  • [New][SQL Editor] Autocomplete menu now can be resized by mouse
  • [New][SQL Editor] Autocomplete menu shows more tooltips about items.
  • [Imp] SQLite to Valentina DB converter improved a lot.

New in Valentina Studio 10.5.7 (Nov 29, 2020)

  • [Imp][Reports] - count controls from sub-reports on stretch controls.
  • [Fix][Reports] - count controls from a sub-report that starts new page.
  • [Fix][Form Editor] ignore changes of the current item in ComboBox on add/remove items, auto-update current item after changes.
  • [Fix]8899[Query Editor] - JOIN tables in the same order as they were added to the Query Editor diagram.
  • [Fix]8900[Query Editor] Existing links between PostgreSQL tables are not shown on the Query Editor diagram after reopen
  • [Fix][Query Editor] Small fix - corrected position of the link attachment point if key fields were added to the existing link.
  • [Fix]8898 - Set correct positions of all reordered columns when applying Data Editor Layout.
  • [PostgreSQL] client libs updated to 13.1, enabling support for PostgreSQL for version 13.0 and higher

New in Valentina Studio 10.5.6 (Nov 7, 2020)

  • Valentina Studio:
  • [New][Form Editor] Added project.getItemByName() method to use in JavaScript. For example, to change the datasource definition in code.
  • [New][Form EDitor] 8892 Add ability to pass default options to report.showPrintDialog called from JavaScript [macOS/Linux]
  • [Imp][Form Editor] Renamed enum for scripts documentation: PROJECT_ITEM_KIND?PROJECT_ITEM_TYPE for consistency
  • [Fix][Form Editor] [FORM EDITOR] fix copy child lists, clean code
  • [Fix]8875 - Fix zoom in the label layout.
  • [Fix]8890 - Ctrl+v doesn't work in SQL Editor when multiple Valentina Studio windows are open.
  • Valentina Server:
  • [Fix]8873 - vServer stuck with “Sending notification error”
  • New message for the log: “Notification connection has been paired with regular connection (UID %d).”

New in Valentina Studio 10.5.5 (Oct 23, 2020)

  • Valentina Studio:
  • [Fix][Import Wizard] Enabled loading/saving mapping in VStudio Single.
  • [Imp][Win] - Speed of Schema Editor.
  • Valentina Server:
  • [Fix][RPI][SQLite] - now it can open SQLite databases > 2.1GB
  • Valentina NET:
  • [Fix] crash in the VField.Find() method if return result is empty.
  • Valentina for Revolution/LiveCode:
  • More steps to improve and polish things.

New in Valentina Studio 10.5.2 (Oct 4, 2020)

  • Valentina Studio:
  • MAS version updated to 10.5.2 release.
  • [Postgres] Fixed missing FKs/PKs in link after refresh
  • [SQL Editor] Fixed showing parameters panel in VStudio Single edition
  • [Data Editor] Made error text selectable, also show it in the tooltip, it helps if the message is too long
  • [Query Editor] Fixed adding tables/views/links from the left panel - smart pointer deleted them before adding to the parent object list
  • [Query Editor] Fixed adding tables from the right panel
  • Valentina Reports:
  • Ability to create recursive reports.
  • [Fix]8874 - size_type=Relative To Region shrinks the height of the rectangle in some conditions.
  • Valentina for Xojo:
  • V4RB: solved issue in RBDB Valentina that after close - open object somehow is invalid - methods were not called by Xojo.
  • Valentina DBL
  • 8872: Crash on reading result of the query containing bind parameters in the select list

New in Valentina Studio 10.5.1 (Sep 27, 2020)

  • Valentina Studio:
  • [New] Menu command “Add To Bookmarks…” on Bonjour discovered items.
  • [New] Menu command “Add To BookMarks…” on a live connection in Schema Editor.
  • [New] Menu command “Discover Localhost Servers” in the menu of Bookmarks column of the Start Page.
  • [Fix] Fixed LParser SkipComment for the case if parsed text starts with a multiline comment. This bug caused a crash for a MSSQL user.
  • [Fix]8864[Data Editor] - Slow vertical scrolling when a table contains a lot of fields.
  • Valentina for Xojo:
  • [Fix] crash when a bind parameter is an empty string, working with vserver.

New in Valentina Studio 10.4.22 (Aug 23, 2020)

  • 0008829: [Feature] [NEW] Additional column "fld_cursors_size" for "SHOW CONNECTIONS" (Ivan Smahin)
  • 0008822: [Database] Database with dot in name produces bunch of issues. (Ivan Smahin)
  • 0008800: [ini-file] Invalid ini-file on irregular service stopping (Ivan Smahin)
  • 0008774: [Docs] Property EmbeddedSerial missing from VSQLiteDatabase (Ivan Smahin)
  • 0008792: [Master database] VDatabaseInfo.Path return path with duplicate separators in Windows (Ivan Smahin)

New in Valentina Studio 10.2.0 (May 6, 2020)

  • 0008771: [API] vServer.Restart command shutdown the server but doesn't restart it in Windows (Ivan Smahin)

New in Valentina Studio 10.1.3 (Apr 24, 2020)

  • [API] vServer.Restart command shutdown the server but doesn't restart it in Windows (Ivan Smahin)
  • [Prefs Pane] Yellow text in pref pane not readable (Ivan Smahin)
  • [Other] Unable to stop server properly on Windows (Ivan Smahin)
  • [API] Using the server.restart command changed properties aren't saved (Ivan Smahin)
  • [Users/Groups] Add ALTER USER SQL command (Ivan Smahin)

New in Valentina Studio 10.1.0 (Mar 12, 2020)

  • [New][Pro][Schema Editor] – Duplicate command in the contextual menu of a Table.
  • in the dialog you can specify also [x] - RAM, [x] - Temporary flags for the duplicate.
  • also you can specify that N records should be copied.
  • works for all databases: MS SQL, MySQL, PostgreSQL, SQLite, Valentina DB.
  • (!!!) keep in mind that MySQL does not expose a temporary table in SHOW TABLEs. To use it in SQL Editor you should remember its name.
  • [New][Pro][Form Editor] - QProcess class, to run external applications, can be used to execute Bash scripts, AppleScript commands, etc.
  • [New][Schema Editor] – improved “Generate SQL : Create” tab, adding flags [x] - RAM, [x] - Temporary for Table objects into dialog.
  • [New][Schema Editor] – cmd+F keyboard shortcut moves focus to the SEARCH-field on the top right.
  • [New][Schema Editor] – now you can filter also the first column of databases.
  • [Imp][Data Editor] – Improve to allow the user to open SQL Editor, Query Editor, Server Admin for active database/connection, using toolbar buttons.
  • [Fix][SSH] – Fixed sending long packets via SSH. This makes the execution of long queries more stable.
  • [Imp][Load Dump] – Update dump loading progress more frequently.
  • [Imp][Load Dump] – Show the list of errors on the last page of the Load Dump wizard.

New in Valentina Studio 9.7.4 (Dec 16, 2019)

  • [Fix][SQL Editor][MySQL] fixes in filtering out of DELIMITER commands.

New in Valentina Studio 9.7.3 (Dec 8, 2019)

  • Valentina Studio:
  • [New][Mac] QT 5.13.1 now is used (it was QT 5.12.1) - This should bring few fixed bugs in QT, for example, fix of TAB-panels move.
  • [New][SQL Editor] Working with MySQL, can filter-out command “DELIMITER delim”.
  • [New][PostgreSQL] Added function category property (FUNCTION or PROCEDURE), fixed Generate SQL for procedures, supported creating procedures in Create Function Dialog
  • [New][PostgreSQL] Show readable function arguments in DROP confirmation dialog
  • Valentina for Xojo:
  • [New] For ValentinaDB RBDB and SQLite RBDB API, added a new method of Xojo 2019 r2.1 - PreparedenStatment.ExecuteSQL()
  • For older builds of Xojo, this method is not registered of course.

New in Valentina Studio 9.7.2 (Dec 8, 2019)

  • Valentina Studio:
  • [Fix][SQLDiff] Fixed showing the name of a changed function (readable parameter types), turned off word wrap for the result table.
  • [Fix][Data Transfer] tool now works for databases with schemas
  • [Fix][Data Editor] fixed not-scrolling horizontally checkbox to mark all records.
  • [Fix]8694[Mac] - Can't quit the application after switching to the fullscreen mode on macOS
  • Valentina DB:
  • [Imp] Diagnose of Table now do 3 additional checks of data consistency.
  • [Fix] crash in Diagnose() - new rare case found.
  • [Fix]8692 - wrong result using “operator →”. New regression test added.

New in Valentina Studio 9.7.1 (Dec 8, 2019)

  • Valentina Studio:
  • [Fix]8672 - Double click on error does not move text on the line with error.
  • [Fix]8685[Lin] - Dark theme can be chosen.
  • Valentina DB:
  • [Fix] crash in the new REPAIR method on a Calculated Field of BLOB/TEXT type.

New in Valentina Studio 9.7 (Nov 14, 2019)

  • Resolved:
  • [SQL] NEW SQL command "DROP PROJECT pro_name"
  • [Property Inspector] Missing SYSTEMPROJECTSCATALOG property of vServer
  • [Property Inspector] [NEW] vServer property SERVERPATH

New in Valentina Studio 9.6.2 (Oct 2, 2019)

  • [New] Support of PostgreSQL 12
  • [Fix]6885 Executing truncate/create in SQL editor not working
  • [Fix]7724 Generated Schema changes remove links / foreign Keys on SQLite

New in Valentina Studio 9.6.1 (Oct 2, 2019)

  • [Fix] crash on open of a diagram. (crash was in UpdateSceneSizeLabel)

New in Valentina Studio 9.6.0 (Oct 2, 2019)

  • [New][Pro][Report Editor] JavaScript now can be used in all places and for all controls with Valentina Reports. Macros $() are to be deprecated.
  • [New][Pro][Report Editor] Objects within Valentina Reports can now be rotated, making it easy to create complex orientation of objects.
  • Objects can be rotated within the Report Editor
  • Objects can be rotated in the generated reports (PDF, HTML, etc)
  • [New] Links within diagrams now have tooltips now with full info about the link
  • [Imp][Prefs] Now supports two new flags “Enable Static Analyzer (experimental)” and “Enable IdentResolver(experimental)”. Because these are features in progress You can disable them. Please help us improve these features by reporting any issues to our MANTIS bug support system.
  • [Imp][SQL Editor] Auto-complete for INSERT, DELETE, UPDATE now show only table/view names, instead of all known idents.
  • [Imp][SQL Editor] The “FROM CODE” button now can remove or clean up from text the following:
  • end-line SEMI, COMMA
  • prefix || operator
  • [Fix][SQL Editor]8625[ValentinaDB] Editor - Templates - SHOW INDEXES command of ValentinaDB
  • [Fix][SQL Editor] - Several static analyzer performance issues
  • [Fix]6383[SQL Editor] - Double click on tblName.fldName should select only one ident
  • [Fix]8388[SQL Editor] - For PostgreSQL, the SQL Editor can now on the fly replace ? parameters with $
  • [Fix]8604[Diagrams] - Auto arrange schema diagrams moves tables past edge of the viewable grid
  • [Fix]8614[DataEditor] - Display related records for the user that is not an owner of linked tables

New in Valentina Studio 9.2.0 (Jun 3, 2019)

  • [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
  • Valentina Reports:
  • [New] 'keep_together' flag for groups headers.
  • Valentina Server:
  • [New][SNMP] allows getting the number of licenses for VDB/SQLite/Reports by SNMP.
  • Valentina Database:
  • [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.

New in Valentina Studio 9.1.1 (Mar 29, 2019)

  • Valentina Studio:
  • [New][Form Editor] Allow sorting records, added methods: addSort(), removeSort(), applySorts(), clearSorts().
  • [New][Form Editor] Add templates of JS code to sort records.
  • [New][Form Editor] Allow to setup sorting via Property Inspector.
  • [Fix][Data Transfer] Transfer of database with schemas
  • [Fix][Schema Editor] Resize columns
  • [Fix] 8475 Need to limit auto width of columns to parent table width.
  • [Fix] 8498 F5 does not refresh Data Editor.
  • Valentina for Xojo:
  • [Imp] One more attempt to make better threading of long tasks for Xojo:
  • Now our YieldRunner uses own approach instead of MySQL plugin.
  • Database_Diagnoze now has Progress Bar and demonstrates how to use Xojo Thread and V4RB to avoid “app not responding” state.

New in Valentina Studio 9.1 (Mar 25, 2019)

  • Valentina Studio:
  • [New][Forms] Added code templates for import of the forms and scripts.
  • [New][Forms] Implement autocompletion for imported forms and scripts (partially).
  • [New][Forms] Call 'needUpdate' slots on click buttons, edit text etc., to update dialogs not linked to a datasource.
  • [New][Forms] 8131 Add property “Mode” for the LineEdit-Field control.
  • [New][Forms] Added 'application.sessionStorage' object to store and pass data during single session.
  • [New][Updates] 8486 Add ability to check for updates using the proxy connection.
  • [New][Schema Editor] Add button to toggle preview panel in Schema Editor for tree mode.
  • [Imp] Big polish of icon-set.
  • [Imp][Sql Editor] Opt-Click on an object name now select this object in the tree, instead of open another Schema Editor.
  • [Fix][Sql Editor] 8485 display non-printable chars in sql-editor
  • [Fix][Data Editor] Fixed pasting tabular data to database with schemas.
  • [Fix] 5259 Fix execute query and refresh result on readwrite cursor.
  • [Fix] 7300 Almost unable to read selected row in table if using dark theme on Linux (KDE).
  • [Fix] 7793 Renamed SQL Snippet is duplicated after application restart - with an old and a new name.
  • [Fix] 8468 Turning off sort fields does not work completely.
  • [Fix] 8470 Form Editor: NULL values are not handled in the ComboBox.
  • [Fix] 8479 Rightmost column sometimes is not visible.
  • [Fix] 8486 Add ability to check for updates using the proxy connection.
  • Valentina Server:
  • [New] Docker for Valentina Server, on Linux, Mac OS X and Windows.
  • Valentina Server Docker Documentation
  • Valentina DB:
  • [New] Totally a new additional way to do SQL Dump. Resolve problem when DB have really HUGE blob data.
  • VDatabase.DumpEx()
  • VDatabase.LoadDumpEx()
  • Valentina ODBC:
  • [Win] Total re-write of VODBC driver.
  • [New] 64-bit archive, additionally to 32-bit.
  • removed dependency on WX framework

New in Valentina Studio 9.0 (Feb 14, 2019)

  • Valentina Studio:
  • [New][Project Window] now has ICON VIEW for project items, additionally to LIST VIEW.
  • [New][Project Window] now shows a preview of reports.
  • [New][SQL Editor] Static Analyzer errors indicator.
  • [New][SQL Editor] Static Analyzer console panel where you can see all errors found by the analyzer.
  • [New][SQL Editor] has menu Default Schemas for PostgreSQL and MSSQL. This allows you to see which schema(s) is currently the default, and allows you to change it.
  • [New][Schema Editor] Ability to create events for Valentina Studio Projects.
  • [Imp] Improved speed of the data preview in Schema Editor tree view mode for tables with large BLOB values.
  • [Imp] SQLite engine upgrade up to 3.26
  • [Imp][Mac] Qt framework upgraded to 5.12
  • [Fix]8452 ImageEditor shows wrong picture
  • [Fix][Data Editor] Fixed duplicating records with BLOB values.
  • Valentina Studio IS ABLE to work with older Valentina Servers.
  • Valentina Server:
  • [New][SQL] 7966 Enables the Scheduler of Valentina Server to work with a backup of a Valentina Project:
  • [New][SQL] 8449 SET PASSWORD OF [USER] username IDENTIFIED BY old_password TO new_password
  • [Chg] Protocol. Both client and server must be upgraded to 9.0
  • [Imp] SQLite engine upgrade up to 3.26
  • [Fix] 8461 inconsistent handling of BACKUP DATABASE.
  • Valentina DB Client:
  • [Chg] Protocol. Both client and server must be upgraded to 9.0
  • Valentina DB:
  • [New] 8325 Arrays in Stored Procedures
  • DECLARE days BOOLEAN[7];
  • SET days = ARRAY[false,true,false,false,false,false,false];
  • SET days[2] = TRUE;
  • [Chg] 8458 RENAME funcs ENODE / DECODE to STR_ENODE / STR_DECODE, because ENCODE is a keyword.
  • [Fix] 8273 Wiki Examples of MERGE command of Valentina SQL.
  • Valentina DB ADK (any):
  • [Chg] 8252 API way only.
  • Removed any mentions of BitSet and ArraySet classes.
  • Removed few methods in VField class with names of these classes, e.g. FindAsArraySet()
  • If your code did use these methods you need change code to use Find() etc methods.
  • SQL way works as before.
  • [Imp] SQLite engine upgrade up to 3.26
  • Valentina for Xojo:
  • [Imp] 8457 Improve internal threading inside of V4RB plugin when a long operation happens.

New in Valentina Studio 8.7.0 (in development) (Nov 22, 2018)

  • New:
  • [New][Diagram Editor][Free]8415 Diagram with ALL tables of a database. In the dialog “Add Tables” now can be found checkbox [x] Add Existing Tables
  • [New][Diagram Editor][Free] - You now can drag and drop a few tables and other objects from the left-side panel to a diagram.
  • [New][Free] Valentina Studio now can connect to Valentina Embedded Server without the special signature.
  • [New][SQL Editor][Pro]8416 Now you can drag and drop objects of a schema from the left sidebar of SQL Editor into edit area. On drop, you will be shown a dialog, where you can choose which command you want to generate and yet some options.
  • [New][SQL Editor][Pro]8417 Underline Not Resolved Idents in major SQL commands.
  • [New][SQL Editor] top-right button to enable/disable this underline.
  • [New][SQL Editor][Pro]8418 fromCode operation. Removes quotes and escapes in the text copied from e.g. C# or PHP into SQL Editor, so we get clean SQL query ready for Execute in Valentina Studio.
  • New menu item “From Code” in the menu “SQL”
  • New button in the toolbar of SQL Editor
  • Can be applied to a selection of text in the SQL Editor
  • [New][SQL Editor][Pro]8419 Execute Current button, which allows executing of only one SQL statement, where the text cursor is located.
  • Fixes:
  • [Fix][Schema Editor][SQL Server]8400 Schema won't display databases on some SQL server instances
  • [Fix][Schema Editor][MySQL]8401 Schema editor in tree mode does not show primary key values when multi-column PK (MySQL)

New in Valentina Studio 8.6 (Sep 21, 2018) (Sep 25, 2018)

  • Valentina Studio:
  • [New][Sql Editor][Pro] - Ability to work with SQL commands that have BIND - PARAMETERS.
  • When you type or copy paste SQL command with bind parameters (?, :n, $n - different for each DB), SQL Static Analysator recognizes parameters and show them in the new right-panel “Parameters”.
  • [New] Use this panel to specify values for each parameter before executing the query.
  • [New] button “hide/show parameters panel”.
  • [New] checkbox “Use Parameters” - allows you to send SQL command that has parameters as a regular command. You may want to do this, e.g. for stored procedures.
  • [New] values of parameters are saved into Recent Queries.
  • [Imp][Form Editor][Pro] - now you can select many controls and edit them together.
  • [Imp][Sql Editor] - notice on the picture above, tab-panel 'Templates' on the left. We have extracted templates from the 'Snippets' panel.
  • [Fix]8356[ValentinaDB] Data Editor did not show numeric values for some types.
  • [Fix][SqlAnalysator] func_name() was not recognized correctly if func_name matched a keyword.

New in Valentina Studio 8.5.0 (Sep 3, 2018) (Sep 3, 2018)

  • Valentina Studio:
  • Script Editor - Autocompletion:
  • [New][Sript Editor][Pro] - big feature, auto-complition for JavaScript classes/objects.
  • Forms - Reports from JS code:
  • [New][JS] classes VProject and VReport, to allow print reports from JS code (i.e. from Forms)
  • SQL Editor - Advanced Edit Commands:
  • [New][SQL Editor][Pro] New commands to improve editing of complex SQL texts and commands:
  • Duplicate Line
  • Move Line UP
  • Move Line DOWN
  • Move Statement UP
  • Move Statement DOWN
  • Move Element LEFT – of some comma-separated list (e.g. SELECT/INSERT sublist)
  • Move Element RIGHT
  • Data Editor - Copy-Paste from Excel:
  • [New][Data Editor][Pro] Copy-paste from excel directly into Table via clipboard.
  • Others:
  • [Improved] Data Editor for remote Valentina DB Servers now uses cursors. This makes work much faster.
  • Valentina DB:
  • [Imp] VARIANT type now can be used in Stored Procedures.

New in Valentina Studio 8.3.9 (Aug 16, 2018) (Aug 17, 2018)

  • [Fix] 8281[SQL Editor] Excel dump number of rows in query result
  • [Fix] 8312 loop on return to query whose results have been deleted
  • [Fix] 8340[MySQL] Don't drop links in the dump if “Drop before restore” option is used (they dropped with tables)
  • [Fix] 8341[MySQL] Ability to split the records into few blocks for multi-row INSERT or transaction
  • [Fix] 8342[MySQL] Fix dumping default field values for the latest MariaDB servers
  • [Fix] [MySQL] Save dump options in the user prefs
  • [Fix] [MySQL] Add DROP DATABASE statement to dump if “Drop before restore” option is used
  • [Fix] [MariaDB] Correct mariadb version for proper quoting (https://mariadb.com/kb/en/library/information-schema-columns-table/)
  • [Fix] 8345[SQLite] shows columns which can't delete and which are invisible in other tools

New in Valentina Studio 8.3.7 (Jul 23, 2018) (Jul 23, 2018)

  • Valentina Studio:
  • [Imp] Added new translations into RU and UA.
  • [Fix] 8311 The pie chart is not printed on Windows.
  • Valentina DB:
  • [Fix] 8310 json_extract_path() crashes.
  • [Fix] 8317 CASE statement with ENUM values crashes.
  • [Fix] 8318 “Simple” DateTrunc function.
  • Valentina Server:
  • [Fix] 8302 Database Events create bogus connections to database which are subsequently blocking unregistering this database.
  • Valentina C++ SDK:
  • [Chg][Win] - Now VSDK contains Valentina MT dlls. They are located in the same vcomponents_win_vc folder. If you want to use them you should specify them in your project. If you do not use them, just ignore.

New in Valentina Studio 8.3.5 (Jul 7, 2018) (Jul 8, 2018)

  • Valentina Studio:
  • [Imp][ValentinaDB] - The default value property of the ARRAY field now can be modified using the array editor (in the Create Table dialog and directly in the Schema Editor).
  • [Fix][ValentinaDB] - Fixed editing the ARRAY field values in the Data Editor.
  • [Fix][ValentinaDB] - Fixed generation of the default value definition of the ARRAY field.
  • [Imp][Form Editor] - Don't reset the source fields on change of the datasource, if possible.
  • [Fix][Form Editor] - Fixed crash on change of the datasource.
  • [Fix][Form Editor] - Fixed an access to the connection's parameters from JavaScript.
  • [Fix][Schema Snapshot] - Don't create the snapshot of the system schemas.
  • [Imp][Schema Snapshot] - PostgreSQL functions file names now include the input parameters type names, not their numeric IDs to be consistent between snapshots.
  • Valentina DB:
  • [Fix] few issues about ARRAY field and its DEFAULT VALUE in the SQL.
  • Valentina Server:
  • [Fix] 8298 - Crash on the creation of a new database with enabled privileges.
  • Valentina C ADK:
  • [Fix] 8296 - Crash in Server_GetVariable()

New in Valentina Studio 8.3.3 (June 27, 2018) (Jun 27, 2018)

  • Valentina Studio:
  • [New] [FORM EDITOR] add 'currentRow' and 'currentColumn' properties
  • [New] [FORM EDITOR] allow to create QStringListModel from JS
  • [New] [FORM EDITOR] allow to change source records for forms/subforms/table views from scripts “this.records = this.dataSource.sqlSelect( …. )”
  • [New] [FORM EDITOR] add methods queryParametersValue/setQueryParameterValue to Form/SubForm/TableView
  • [New] [REPORT EDITOR] allow to convert controls via menu
  • [Fix] 8283 - Cannot connect to MS SQL through SSH tunnel.
  • [Fix] 8285 - JOIN is not generated for links created in the Query Editor in PostgreSQL database.
  • [Fix] [Query Editor] Fixed saving Query Editor own links for databases with schemas
  • [Fix] [FORM EDITOR] fix apply query's default parameters on import form

New in Valentina Studio 8.3.2 (June 10, 2018) (Jun 12, 2018)

  • Valentina Studio:
  • [New][Form Editor] - The HyperLink control which opens a default browser window with the specified URL or executes a custom script.
  • [New][Form Editor] - The Image - Field control for displaying an image stored in the BLOB/Picture field or loaded by the URL stored in the textual field.
  • [Fix] 8281 - Excel dump result in more rows than the query result.
  • Valentina DB:
  • [Fix] 8278 - ERR string is not readable.

New in Valentina Studio 8.3.1 (June 3 2018) (Jun 5, 2018)

  • Valentina Studio:
  • [New][Form Editor] - add 'records' property for form, subform and tableview.
  • [New][Form Editor] - add 'Reload Records' actions.
  • [New][Form Editor] - Automatically update TableView on change of the field it is linked to in the form.
  • [Imp][SQL Editor] - Show the connection and database selection controls above the Schema/Queries/Snippets tabs.
  • [Fix][Schema Editor] - sorting by size (e.g of Fields) in the Tree View.
  • [Fix][PostgreSQL] Don’t generate RETURN NULL statement in the function body automatically
  • Valentina DB:
  • [Fix] 8267 - corruption of compressed Blob on ALTER TABLE.
  • [Fix] 8279 - EXPORT to TAB-separated text file now do not add BOM prefix to each line.
  • Valentina Server:
  • [Fix] 8268 - in 64 bit installer fixed runtime dlls of visual. Was used 32 bit dlls.

New in Valentina Studio 8.3 (May 22 2018) (May 23, 2018)

  • Valentina Studio:
  • [New] Forms for Query
  • [New] Sub Forms for Table/View/Query
  • [New] Show related records in the TableView using the map of fields or map of parameters
  • [Fix] 8259 High CPU usage with SSH tunnel after switch between different internet connections
  • Valentina DB:
  • [New] db.Diagnose() now works in multi-thread way if logging of diagnosing disabled.
  • Valentina Server:
  • [Chg] - Now Valentina Server always is MT version (improved multi-threading). We have removed separate archives of Server_MT.
  • [Fix] 8264 - broken processing of “BACKUP DATABASE”.

New in Valentina Studio 8.2 (Apr 16, 2018)

  • Valentina Studio:
  • [New][Win] Updated from QT 5.6 to QT 5.10.1, what fixes at least 3 known issues in Valentina Studio
  • [New][SQL Editor] Displays progress of export to SQL, with the ability to stop the export
  • [Imp] Select the current date in the calendar of the event editor
  • [Fix] 8234 SSL for Postgresql connections in Valentina Studio 8.1
  • Valentina for .NET:
  • [Imp] Valentina for .net was rewritten to meet the new syntax standards for Managed Code
  • [Chg][Examples][C#] All C# examples now explicitly specify .vdb for name of database
  • [Todo][Examples][VB.net] Specify .vdb for names of database

New in Valentina Studio 8.1 (Mar 14, 2018)

  • Valentina Studio:
  • [New][Form Editor] Add actions to add/remove filter
  • [New][Form Editor] Add 'clearFilters' method for cursors
  • [New][Form Editor] Add 'returnPressed' slot for line editors
  • [New][Form Editor] Make 'key' argument for 'addFilter' optional
  • [New][PostgreSQL] Dump now uses pg_dump binaries as is. (Before we compiled their sources inside of our vs_postgre_plugin)
  • [New][PosgtreSQL] Download another version of pg_dump (newer or older) and set Valentina Studio to use it
  • [New][PostgreSQL] Valentina Studio can find and download newer binaries of pg_dump from Github
  • [Fix][SQL Editor][Postgre SQL] Highlighting quoted identifiers, postgre SQL functions
  • Valentina Reports:
  • [New] add 'Equal To', 'Less Than' and 'Greater Than' to conditional styles
  • [Imp] Store background/foreground in a control instance to allow to change it from a script
  • Valentina DB:
  • [Imp] improved speed of db.ge_Table(name)

New in Valentina Studio 8.0.2 (Feb 26, 2018)

  • Valentina Studio:
  • [Fix][Form Editor] - fix icon size on Linux with gtk breeze theme
  • Valentina Reports:
  • [Fix] - Evaluation of record index in the footer
  • Valentina DB:
  • [Fix] 8192 - JSON_TO_ARRAY() method now recognizes int/double values better
  • [Fix] 8195 - Opening of encrypted db with ENUM field
  • [Fix] 8197 - Load SQL dump with huge literals (megabytes)
  • Valentina C ADK:
  • [New] - Methods Project_Free(), Report_Free()
  • [Fix] - crash in Valentina_InitReports() do not log before init vdb kernel.

New in Valentina Studio 8.0.1 (Feb 21, 2018)

  • Valentina Studio:
  • [New] FREE Valentina Studio works as a runtime for local and server-registered Valentina Projects
  • [New] FREE Valentina Studio can act as a demo for Valentina Forms creation, save disabled
  • [New] Array Editor inside of Data Editor, to support new ARRAY field type in Valentina DB.
  • [New][Wiki] Data Editor - Arrays
  • [New][Wiki] Form Editor Help
  • [New][Wiki] Valentina Studio Tutorials : Forms

New in Valentina Studio 8.0 (Feb 13, 2018)

  • Valentina Studio:
  • Valentina Forms is brand new feature and visual paradigm in Valentina Studio.
  • [New] FREE Valentina Studio works as a runtime for local and server-registered Valentina Projects
  • [New] FREE Valentina Studio can act as a demo for Valentina Forms creation, save disabled
  • [New] Array Editor inside of Data Editor, to support new ARRAY field type in Valentina DB.
  • [New][Wiki] Data Editor - Arrays
  • [New][Wiki] Form Editor Help
  • [New][Wiki] Valentina Studio Tutorials : Forms
  • [New] Valentina Forms - the most requested feature in Valentina Studio:
  • [New][PRO]Add forms to Valentina Projects (local and also registered on Valentina Server)
  • [New][PRO]Powerful Form Editor to visually create | execute | save Valentina Forms to Valentina Projects
  • [New][PRO]Drag-drop widgets, controls and layouts, resize layout canvas to visually create forms
  • [New][PRO]Register and edit Valentina Projects with Valentina Forms to Valentina Server
  • [New][PRO]All widgets, controls, and layouts in Valentina Forms scriptable with JavaScript
  • [New][PRO]Documentation for all classes, enums, global constants and more for use in JavaScript in Valentina Forms
  • [New][PRO]Snippets library for often used code snippets and custom code snippets
  • [New][PRO]Valentina Form data sources support all other supported data sources (not only Valentina DB, SQLite, but also MySQL, PostgreSQL, etc)
  • Valentina Server:
  • [NEW] REST API - support of ValentinaDB ARRAY type via SQL binding
  • [NEW] Registered Valentina Projects now support serving Valentina Forms to Valentina Studio
  • Valentina DB:
  • [NEW] ARRAY field type according to SQL 2003 standard: a single dimension, fixed size.
  • [NEW] Set of SQL functions to work with ARRAY fields. (about 15-20 funcs).
  • Valentina for Xojo:
  • [NEW] VArray class - to support ARRAY fields.
  • [NEW] VTable.CreateArrayField() method
  • [NEW] VSqlStatement.Bind_array method
  • Valentina for .NET:
  • [NEW] VArray class - to support ARRAY fields.
  • [NEW] VTable.CreateArrayField() method
  • [NEW] VSqlStatement.Bind_array method
  • Valentina for Java:
  • [NEW] VArray class - to support ARRAY fields.
  • [NEW] VTable.CreateArrayField() method
  • [NEW] VSqlStatement.Bind_array method
  • Valentina for LiveCode:
  • [NEW] VArray class - support ARRAY fields.
  • [NEW] VTable.CreateArrayField() method
  • [NEW] VSqlStatement.Bind_array method
  • Valentina for Director:
  • DEPRECATED
  • We stopping to support this product and produce builds for it.
  • We make latest existing builds of V4MD to be free. Get a free license if you want.
  • Valentina COM:
  • DEPRECATED
  • We stopping to support this product and produce builds for it.

New in Valentina Studio 7.5.9 (Feb 9, 2018)

  • Valentina Studio:
  • [Fix] 8164 Save and restore the size of the Edit Query dialog.
  • [Fix] 8166 Fix opening the SQL Server database with Cyrillic symbols in name [Windows].
  • [Fix] 8167[MSSQL] Fix showing the image returned by the SQL Server.
  • [Fix] 8169[Report Editor] “Sort by Fields” dialog works only for 2 fields, but not 3, 4, …
  • [Fix] 8171[PostgreSQL] Fix Data Editor Layout saving for PostgreSQL table.
  • Valentina Reports:
  • [Fix] 8179 Date formatting in the Expression control outputs only time for $F() macro [Valentina].
  • Valentina DB:
  • [Fix] 8168 MultiRow-binding (prepared SqlStatement) could ignore some bind rows.
  • [Fix] 8173 ABS( '1' ) returns empty string instead of numeric 1 value.
  • [Fix] 8176 The database locale is not applied to the SQL FORMAT() function.

New in Valentina Studio 7.5.8 (Jan 10, 2018)

  • [Chg][Report Editor] Now shows the size of fonts in points instead of pixels.
  • [Fix][PostgreSQL] Dump updated to latest version.
  • [Fix] 8156[Query Editor] doesn't add the schema name for the tables when generating the JOIN.
  • [Fix] 8157[Query Editor] When the alias is set for one of the linked tables, the JOIN operation is not generated at all.

New in Valentina Studio 7.5.4 (Nov 15, 2017)

  • Valentina Studio:
  • [New] 8114 - “File…” menu now has a new item “Open File…” for .sql files. Opens them directly in SQL Editor.
  • [Imp] 8105[Data Editor] - Add ability to set NULL value for multiple records.
  • [Fix] 8063 - “Links” not included in “Generate SQL → Create” for table (ActionGenerateSQLCreateHandler).
  • [Fix] 8093[Query Log] - It now sorts by time.
  • [Fix] 8113[Query Editor] - Crash when Query Editor is opened for closed database.
  • [Fix] 8115[PostgreSQL] - Refreshing the PostgreSQL schema or database objects changes the text of all views to the default (SELECT 1).
  • [Fix] 8117[DataEditor][SQLite] - Unable to work with big integer values in DataEditor and SQLite table.
  • [Fix] 8126[PostgreSQL] - Fix reindex action of PostgreSQL table.
  • [Fix][PostgreSQL] - Error on getting PostgreSQL 10 sequence properties.
  • Valentina DB:
  • [Imp][SQL] - MERGE command now works with VIEW also.
  • Valentina C ADK:
  • [Fix] 8108 - Added VServer_Free().

New in Valentina Studio 7.5.3 (Nov 6, 2017)

  • Valentina Studio:
  • [New] 8087[SQL Editor] - Add ability to switch the source connection of the SQL Editor.
  • [New][PostgreSQL] - Support of Event Trigger.
  • [Imp] - Diagrams, Schema Editor → Design dialog get the ability to change the order of children objects in NEW objects.
  • [Fix] 8088[SQLite] - Fix creation of the second foreign key in the SQLite table.
  • [Fix] 8092[PostgreSQL] - Schema Editor hangs on very huge Tables.
  • [Fix] 8094[SQLite] - Newly created SQLite link is not added as a child to table, only to the database.

New in Valentina Studio 7.5.2 (Oct 30, 2017)

  • Valentina Studio:
  • [Fix][SQLite] - Parser fixed - underscore is allowed at any place of non-quoted identifier
  • C++ ADK:
  • [Fix] - Examples fixed to take into account the fact UTF16 string, used as KEY.
  • Valentina DB:
  • [Imp] - LIKE/ILIKE now use IndexByWords even for CONTAINS search of kind '%str%' if between %% present only one word, i.e. no word-delimiters.
  • This makes search 250 times faster in our bench. For example, 1GB TEXT field with 50K records do search 0.016 miliSec instead of 5 sec.

New in Valentina Studio 7.5.1 (Oct 19, 2017)

  • Valentina Studio:
  • [New][Data Editor] - Column has the auto-size contextual menu, and button Auto-Resize similar to SQL Editor.
  • [Fix][VReport][Windows] - 'papersource' parameter in print dialog was broken.
  • Valentina Reports:
  • [New] - Methods PrintToLocalPrinter/PrintToServerPrinter has string to be sent to printer. Now, this string can have 'papersource' parameter.
  • Valentina DB:
  • [Imp] - A lots faster! x4-x50 times faster Building of IndexByWords for Text/VarChar.
  • Benches show the speed up x4 - x40 times.
  • 2GB TEXT data are indexed in about 100 seconds on MacBook 2016.

New in Valentina Studio 7.5 (Oct 5, 2017)

  • Valentina Studio Pro:
  • [New][Start Page] - “Recent Databases” and “Recent Projects” now show items sorted by date, most recent on top. New clock-icon allows you see items sorted alphabet.
  • [Fix] - Table Alias auto-completion now shows RecID and OID fields.
  • Valentina Studio:
  • [New][Data Editor] - Filter Rows now has (X) icon on the left side to REMOVE it.
  • Do OPTION+CLICK (ALT on Win/Linux) to remove all filer rows at once.
  • [Imp] - In diagrams “Save Changes…” changed to “Apply Changes…”
  • [Imp] - Valentina Server - Create Database dialog now allows choose a database mode (1-4 files).
  • [Fix] - In Filter of Data Editor now “CMD + E” works while you in edit mode of a filter cell.
  • [Fix][Data Editor] - When switching to another table the current filter is removed because it has no sense for another table.
  • Valentina Server:
  • [Imp][REST] - Examples improved to use Python lists as is. Transformation to XML/JSON happens inside of helper script now.
  • [Fix] 8068 - Cannot create KeyValue when vdb is under VSERVER.
  • Valentina DB:
  • [New] - “LINK RECORD(LAST) OF T1 WITH RECORD(LAST) OF T2”, you can use now LAST keyword to specify the last_recid_of_table(“T”).
  • [Imp] - SELECT … FOR XML, FOR JSON and REST now supports VARIANT field type.
  • [Imp] - SHOW VIDENTS now returns names of KeyValue objects.
  • [Imp] - TRUNCATE TABLE now works for a Table with Links if all Links are empty.
  • [Imp] - Exceptions about date/time now shows the current DateTime format and separators, so a developer can easily understand what to change.

New in Valentina Studio 7.4.3 (Sep 14, 2017)

  • Valentina Studio Pro:
  • [New][StartPage] - shows local deleted Databases for ValentinaDB and SQLite with strikeout font. Also for local deleted Projects.
  • [New][DataEditor] - Editor for TEXT fields now has SEARCH field, to allow you make search inside of big texts.
  • Valentina Server:
  • [Fix] now prints info about REST commands into log file.
  • Valentina Reports:
  • [New] - Now the images are inserted in the original resolution (for printer, PDF, HTML, SVG).
  • Valentina DB:
  • [Imp] Improved few issues for Multi-threading.
  • [New][C++][Example] - VSDK/Examples/Multithreading/Multithreading_Dbs_Select/Multithreading_Dbs_Select.cpp
  • Valentina ADK:
  • [New] - Mac and Win FTP folders now contain ZIP archives of vcomponents folders. This allows you download them and use to build cross-platform apps on any OS.

New in Valentina Studio 7.4.2 (Sep 14, 2017)

  • Valentina Studio:
  • [Fix] 8057 - Fix crash during painting the LButtonFlat on macOS
  • Valentina Server:
  • [Fix] 8056 - VClient doesn't close the socket stream if connection attempt was made to inactive server
  • Valentina DB:
  • [Imp][Speed] - Indexing and VarChars should be a little faster.

New in Valentina Studio 7.4.1 (Aug 27, 2017)

  • Valentina Studio Pro:
  • [New][All] 7879 - SchemaEditor can expand/collapse the sub-tree of child objects if you do Option/Alt click on a Tree item.
  • Valentina Studio:
  • [Fix] 7919 - Delete Multiple Fields From Context Menu Only Deletes one.
  • [Fix] 8054[MariaDB] - Fix crash on the check of bookmarks after some time.

New in Valentina Studio 7.4 (Aug 21, 2017)

  • Valentina Studio Pro:
  • [New][All] - Connection, Database, Table - can be now assigned a COLOR. Read More ....
  • Valentina Studio:
  • [Imp] - ImportWizard added ability to STOP import process.
  • [Imp] - ImportWizard added display of time for import.
  • [Fix] 7928 - [MSSQL] Improve connection procedure for Azure service (0007928), formatting.
  • [Fix] 8011 - [MSSQL] SQL Server stored procedure definition should not include empty parentheses).
  • [Fix] 8021 - Fix connection to MySQL with an SSL Encrypted Connection.
  • [Fix] 8036 - [PostgreSQL] dump not working when connected via ssh tunnel.
  • [Fix] 8038 - [SQLite] Use prepared statements for loading data from the CSV file.
  • [Fix] 8043 - [MySQL] Field Position column sort order not correct.
  • [Fix] - [MySQL] fixed “Unknown system variable 'version_comment'” for version < 5.0.22.
  • [Fix] - [MySQL] fixed “SHOW TRIGGERS…” for version 5.0.10.
  • Valentina Server:
  • [New] 7978 - LICENSECATALOG property in the INI file, allows you to specify vlicenses catalog to be at any place of HDD. Good e.g. for ISP hosting.
  • [Fix] 8014 - Inconsitency in database name parameter using Register/Unregister Database.
  • Valentina DB:
  • [New][SQL99] 8039 - Now works Row Constructor Comparisions. For example: WHERE (f1, f2) = (3, 4)
  • [Imp][Speed] - Indexing of String[3] field in our new bench, improved from 150 secs to 5 seconds for 100M records Table and 1 such field.
  • [Imp][Speed] - Import from CVS file into Table, Bench of import 500Mb files improved from 7 min 40 sec to 4 min 30 sec.
  • [Fix] 8050 - sql OUTER JOIN issue on BinaryLink.

New in Valentina Studio 7.3.4 (Jul 27, 2017)

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

New in Valentina Studio 7.3.3 (Jul 27, 2017)

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

New in Valentina Studio 7.3.2 (Jul 12, 2017)

  • 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

New in Valentina Studio 7.3.1 (Jul 6, 2017)

  • 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:
  • [New] 8005 - Shows a new property 'Host OS' of Valentina Server 7.3.1 in the Property Inspector.
  • [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.
  • [Fix][MySQL] 7987 - Lost connection with MySQL server error for bigger queries.
  • 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.

New in Valentina Studio 7.3 (Jun 21, 2017)

  • Valentina Studio Pro:
  • [New][PostgreSQL] - SQL Editor Result now can be edited in place! Double click a cell and edit it. This will create and send UPDATE command, also the result buffers will be updated.
  • TODO the same behavior for MySQL and ValentinaDB.
  • Valentina Studio:
  • [New] - Import of diagrams from 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.

New in Valentina Studio 7.2 (Jun 6, 2017)

  • Valentina Studio Pro:
  • New] - Drag&Drop now works in the Schema Editor for such operations as:
  • Drag of a Table or any other DB object into another DB.
  • Drag of a Field or any other Table object into another Table.
  • and others
  • Valentina Studio:
  • New] - Drag&Drop works only once per launch of app. Still can be usefull.
  • Fix] 7967 - Can’t create a new database on SQL Server running on Linux

New in Valentina Studio 7.1.6 (Jun 6, 2017)

  • Valentina Reports:
  • [New] 7981 - Implement 'fit_in_page' property of sub-report. This property allows you to keep the parent record with subreport on the same page, if subreport do not fits the page then parent record and subreport go to the next page.

New in Valentina Studio 7.1.5 (May 25, 2017)

  • ValentinaDB:
  • [NEW][VSQL] You can do now CROSS JOIN. You should use explicit form: … FROM T1 CROSS JOIN T2 …

New in Valentina Studio 7.1.4 (May 18, 2017)

  • Valentina Studio:
  • [New][SQL Editor] Button to Cancel long queries. Implemented for MySQL, PostgreSQL, MS SQL Server.
  • [New] Password field now has button to show letters instead of '•'
  • Valentina Server:
  • [Fix] 7969 - Number of AffectedRows returned is always zero on SQL UPDATE and DELETE on a SQLite DB using REST API.
  • Valentina for Xojo:
  • [Fix] 7970 - One more improve protection when String with NIL encoding passed from Xojo to plugin.

New in Valentina Studio 7.1.3 (May 15, 2017)

  • Very minor fixes in already made fixes.
  • Some win products of 7.1.2 did have problems (rebuild have helped).

New in Valentina Studio 7.1.2 (May 13, 2017)

  • ValentinaDB:
  • [Fix] for tmp tables.
  • Valentina Reports:
  • [New] Subreport now have property 'indpendent', which cause its printing from a new page using its ORIGINAL format. Thanks to this you can get in PDF, for example, the first page as US Letter portrate, and the next page(s) as US Letter landscape (or any other format you want).

New in Valentina Studio 7.1.1 (May 9, 2017)

  • ValentinaDB:
  • [Fix] 7960 - False warning on sorting by RecID/OID fields.
  • Valentina Studio Pro:
  • [New] - Project Tree - filter added to easy find project items.
  • Valentina Studio Pro:
  • [Imp] - polish of “Show On Disk” in few places.
  • Valentina for Xojo:
  • [Fix] 7961 - Crash on connection to VServer from V4RB on Linux.
  • [Fix] - Example about VEnum field type.

New in Valentina Studio 7.1.0 (May 4, 2017)

  • Valentina Studio Pro:
  • [NEW][JavaScript] - Integration of QT JavaScript engine:
  • JS objects integrated to QT GUI objects.
  • JS objects integrated to DB objects of VStudio
  • Script Editor with auto-completion and syntax coloring
  • HELP for JS objects.
  • Few Examples that db Code Generation for Xojo.
  • [NEW][Data Editor] - Update ALL/FILTERED/SHOWN values of a field for multiple records.
  • [NEW][SQL Editor] - Format text of SQL queries.
  • Valentina Studio:
  • [NEW][VDB][Data Editor] - Edit data of KeyValue object.
  • [NEW][SQL Editor] - Export SQL result to Excel XLSX format, including images.
  • [NEW] Dump database to Excel XLSX format, including images.
  • Docs + Wiki:
  • [NEW] Valentina Studio Examples : JS Scripts
  • [NEW] Data Editor - Variant Field page.

New in Valentina Studio 7.0.4 (Mar 24, 2017)

  • VStudio:
  • [New][CmdLine] 7915 - New command line parameters.
  • to connect to some host and db
  • to open SQL Editor on start
  • to load some text file with few SQL commands, they then are loaded into SQL Editor
  • to execute that command also.
  • Valentina Server:
  • [Fix] 7903 - Fixed slow down when Notifications used.
  • VKernel:
  • [Fix][SQL] Money type for VARIANT field fixes.
  • [Fix] KeyValue's LIMIT/OFFSET issue fixed.
  • Docs + Wiki:
  • [New][VStudio] - wiki page about new command line parameters

New in Valentina Studio 7.0.3 (Mar 6, 2017)

  • VStudio:
  • [New][SQL Editor] Export button now has “Clipboard” item. Allows use clipboard to move result records into e.g. Excel.
  • [Imp][SQL Editor] Added templates for new KeyValue commands of Valentina DB.
  • [Fix] 7875 - Ability to set locale to format money or date values.
  • [Fix] 7892 - The newly created ENUM type are not displayed in the GUI.
  • VKernel:
  • [Fix] 7878 - CREATE KEYVALUE command now has IF NOT EXISTS option.
  • [Fix] 7893 - Inconsistency documentation functions FLOOR, CEIL, TRUNC, ROUND and others…
  • VCSDK:
  • Added missing headers.

New in Valentina Studio 7.0.2 (Feb 27, 2017)

  • VStudio:
  • [Fix] 7884 - Changing a locale for Valentina DB doesn't work
  • [Fix] 7885 - Interactive parameters values for date or time should be formatted using Valentina formats
  • [Fix] 7886 - Cannot export to CSV
  • V4RB:
  • [Imp] Example for Valentina SQLite Server: Examples/RBDB_way/SqliteExampleModified updated to be consistent with the current example of Xojo. Also was update corresponded Valentina WIKI tutorial.

New in Valentina Studio 7.0.1 (Feb 20, 2017)

  • V4RB:
  • [Fix] str(intNumber) of Xojo can produce string with ASCII encoding. We take this into account now.

New in Valentina Studio 7.0.0 Beta 1 (Jan 19, 2017)

  • VALENTINA KERNEL:
  • [NEW] VARIANT Field
  • [NEW] KeyValue Store (simple but powerful enough)
  • [NEW] I_SqlStatement interface and supporting methods:
  • [NEW] I_SqlStatement_Ptr I_SqlDatabase::CreateStatement( inSqlStr )
  • [NEW] API Methods to parse ENUM Type string returned by VKERNEL. They help to build a GUI app, which use VENUM type with different languages.
  • EnumType_GetLocales( str )
  • EnumType_GetLocaleItems( str, locale_name )
  • Valentina SQL:
  • [NEW] keywords: VARIANT, KEYVALUE, KEYVALUES
  • [NEW] KeyValue commands:
  • CREATE KEYVALUE
  • DROP KEYVALUE
  • SHOW KEYVALUES
  • KEYVALUE DELETE
  • KEYVALUE GET
  • KEYVALUE SET
  • KEYVALUE UPDATE
  • KEYVALUE UPSERT
  • VALENTINA REPORTS:
  • [NEW] - Controls have new size_type property, which allows to grow if the region grows.
  • Report Parameters:
  • [NEW][VS Report Editor] now is able to show all parameters of report in the layout mode .
  • [NEW][VS Report Editor] now allows to specify the TYPE for a report parameter.
  • [NEW][VS Report Editor] now is able to show DIALOG with parameters of reports, so user can make choice. Zero programming
  • JavaScript Support:
  • [NEW] - VREPORT.DLL now is integrated with JS engine (v8 from Google).
  • [NEW] - Each report control now can have two JS-script pre and post.
  • VALENTINA SERVER:
  • [NEW] - KeyValue multi-user store via Valentina SQL and API of VCLIENT.
  • VALENTINA CLIENT:
  • [NEW] I_KeyValue / VKeyValue interface
  • VALENTINA STUDIO:
  • [NEW] Localization to German, Ukrainian, Russian.
  • [NEW] Convertor: SQLiteDB to Valentina DB.
  • [NEW][PRO] Ability to modify keyboard shortcuts and create own shortcuts sets.
  • [NEW][PRO] Data Editor can have several Layouts where you specify:
  • which fields to show and their order in the main browser
  • related table, fields and their order in the related browser.
  • [NEW][PRO] Data Editor - jump to a parent record, by ALT+Click to value of FK or ObjectPtr.
  • [NEW][PRO] Support of Database Continuous Integration - production of 4 scripts to keep in GIT.
  • [NEW][PRO] Ability to save the database Schema Cache in file and restore it when you open this database the next time.
  • VALENTINA ADKS:
  • Common Part:
  • [NEW] VVariant Class
  • [NEW] Support of KeyValue:
  • [NEW] VKeyValue class
  • [NEW] VKeyValueForTable class
  • [NEW] VKeyValueForLink class
  • [NEW] VDatabase.CreateKeyValue()
  • [NEW] VDatabase.DropKeyValue()
  • [NEW] VDatabase.KeyValue(name)
  • [NEW] VDatabase.KeyValue(index)
  • [NEW] VTable.CreateKeyValue()
  • [NEW] VTable.DropKeyValue()
  • [NEW] VLink.CreateKeyValue()
  • [NEW] VLink.DropKeyValue()
  • [NEW] Support of VSqlStatement:
  • [NEW] VSqlStatement class
  • [NEW] VDatabase.CreateStatement( inSqlStr )
  • [NEW] VENUM string parsing 2 methods in Valentina namespace:
  • [NEW] Valentina.EnumTypeGetLocales( str )
  • [NEW] Valentina.EnumTypeGetLocaleItems( str, locale_name )
  • VRUBY:
  • [NEW] Support of VProject and VReport classes
  • Docs + Wiki:
  • [NEW] VSqlStatement class
  • [NEW] VKeyValue class
  • [NEW] VKeyValueForTable class
  • [NEW] VKeyValueForLink class
  • [NEW] VVariant Class
  • [Upd] VDatabase class - added KeyValue info.
  • [Upd] VTable class - added KeyValue info.
  • [Upd] VLink class - added KeyValue info.
  • VSQL Grammar update for new SQL commands

New in Valentina Studio 6.6.5 (Dec 9, 2016)

  • Valentina Kernel:
  • [Fix] 7820 - Issues in compound indexes.
  • Valentina Studio:
  • [Fix] 7804 - Can't close the error message if the user has insufficient privileges to get MySQL VIEW definition
  • [Fix] 7827 - Show approximate row count for big SQL Server tables
  • [Fix] 7828 - SqlDiff does not add escape characters to table's comment

New in Valentina Studio 6.6.4 (Dec 1, 2016)

  • Valentina Kernel:
  • [Fix] 7818 - Crash on expression with some aggr functions on join.
  • [Fix] 7820 - Issues in compound index with its diagnose.
  • Valentina for Xojo:
  • [Fix] 7821 - Int32 numbers returned by V4RB-64 plugin are incorrect.
  • Valentina Studio:
  • [Imp] - Report Editor: Action added into datasource menu to show the datasource connection string. Easy to copy into your ADK code.
  • [Imp] - PostgreSQL updated pg_dump library.
  • [Fix] 7812 - Reports, Table control with more than 14 columns is not printed.
  • [Fix] 7814 - SQLite, Values of REAL fields are not formatted properly sometimes.

New in Valentina Studio 6.6.3 (Nov 23, 2016)

  • Valentina Kernel:
  • [Fix] 7807 - Crash in load SQL dump after new VLEXER.
  • Valentina Studio:
  • [Imp] 7806 - Now we can display field BIT of mySQL.
  • [Fix] 7810 - Report Editor: Table control editor inserts a new column at wrong position.

New in Valentina Studio 6.6.2 (Oct 17, 2016)

  • Valentina Kernel:
  • [Fix] 7781 - skip “create index” for indexed field like vBoolean (always indexed) making SQL dump. Related to #7779
  • [Fix] 7782 - Crash in load SQL dump after new VLEXER.
  • [Fix] 7783 - Create Event lost 1 token in action after new VLEXER.
  • Valentina Studio:
  • [Imp] 7760 - Add “Design…” into contextual menu for a field in Schema Editor.
  • [Fix] 7776 - Create Field In Import Wizard - new field does not appear in wizard.
  • [Fix] 7779 - Valentina Studio always attempts to create an index for existing boolean VDB field in design mode.

New in Valentina Studio 6.6.1 (Oct 7, 2016)

  • Valentina Studio:
  • [Fix] 7761 - sort_fields initially not cause effect?
  • [Fix] 7763 - Discrepancies in the menu names
  • [Fix] 7765 - Don't save size of varchar fields working on diagrams.
  • [Fix] 7771 - Impossible to open SQLite database with cyrillic characters in path on Windows
  • [Fix] 7772 - Server Admin is unable to register a Valentina database on the server if it has an extension
  • [Fix] 7773 - Change of verbosity level from Server Admin for Valentina Server is not applied
  • [Fix] 7774 - Valentina Studio creates “vlogs” folder at wrong location for user with cyrillic characters in name on Windows

New in Valentina Studio 6.6 (Sep 23, 2016)

  • [Fix] 7759 - Deleting field in schema editor causes crash.

New in Valentina Studio 6.5.12 (Sep 3, 2016)

  • Valentina Studio:
  • [Imp] 7725 Implement auto reconnect if PostgreSQL connection is interrupted.
  • Valentina Server:
  • [Fix] 7754 DROP EVENT crashes.

New in Valentina Studio 6.5.11 (Aug 27, 2016)

  • Valentina Studio:
  • [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.

New in Valentina Studio 6.5.10 (Aug 17, 2016)

  • [New] Support MS SQL Azure.

New in Valentina Studio 6.5.8 (Jul 5, 2016)

  • Valentina Studio:
  • [Fix] 7696 Some improvements in SQL Query Editor for retina display. Still some glitches present because of reported QT bug.
  • Valentina Kernel:
  • [Fix] 7645 Dump script for sequence does not restore the current value.

New in Valentina Studio 6.5.7 (Jul 5, 2016)

  • Valentina Studio:
  • [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.
  • Valentina Kernel:
  • [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.

New in Valentina Studio 6.5.6 (Jun 2, 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][Max] slow drag and drop

New in Valentina Studio 6.5.4 (Jun 2, 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.

New in Valentina Studio 6.5.3 (May 24, 2016)

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

New in Valentina Studio 6.5.2 (May 6, 2016)

  • [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 in Valentina Studio 6.5.1 (May 6, 2016)

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

New in Valentina Studio 6.5 (May 6, 2016)

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

New in Valentina Studio 6.4.1 (May 6, 2016)

  • [Fix] - PostgreSQL dumps
  • [Fix] - New Report Control Table was not enabled for release build.

New in Valentina Studio 6.4 (May 6, 2016)

  • [New] - FREE Report Viewer.
  • [New] - Report Control – Table. Very powerful control that allows you create in a report grid of data by few clicks.
  • [New] - Command Line Interface to print reports from terminal or automation scripts.
  • [Fix] 7363 - Improvements for dialog Create Link
  • [Fix] 7501 - Tool - Data Transfer
  • [Fix] 7547 - [ODBC] The name of fields list is 'Tables'
  • [Fix] 7548 - [ODBC] Generate SQL → Create produces broken SQL
  • [Fix] 7550 - [ODBC] Application crashes on execute query
  • [Fix] 7551 - The data transfer does nothing

New in Valentina Studio 6.3.5 (May 6, 2016)

  • [Fix] 7489 - Null value violates NOT NULL constraint in data transfer tool - PostgreSQL
  • [Fix] 7510 - [mySQL] There is no AUTO_INCREMENT in keywords
  • [Fix] 7515 - Group selection of projects has non-working menu item
  • [Fix] 7516 - Closing of the set of databases leads to showing the confirmation dialog for each item
  • [Fix] 7519 - [mySQL] Default value for blob
  • [Fix] 7521 - Crash on delete copied items
  • [Fix] 7523 - Apply value in the active cell on press Apply
  • [Fix] 7524 - [MYSQL] Flags indexed and unique for BlOB fields
  • [Fix] 7525 - [MYSQL] MySQL does not support autoincrement for decimal
  • [Fix] 7526 - [MYSQL] Query to change flag INDEXED
  • [Fix] 7528 - [POSTGRE] Empty selection for field type
  • [Fix] 7531 - [POSTGRE] Property Dimensions has no tooltip
  • [Fix] 7532 - [POSTGRE] IMPORTANT Issues for VARCHAR
  • [Fix] 7533 - [MSSQL] Issues for create database dialog
  • [Fix] 7536 - [MSSQL] Issues for the fields properties
  • [Fix] 7538 - Default values of object properties should not take a part in the query to create or modify object
  • [Fix] 7544 - Add fields for export by double click
  • [Fix] 7545 - Crash on loading dump to existing database, initiated from connection
  • [Fix] 7546 - 'can_grow' works only for the first record

New in Valentina Studio 6.4b10 Beta (Mar 24, 2016)

  • [New] - FREE Report Viewer.
  • [New] - Report Control – Table. Very powerful control that allows you create in a report grid of data by few clicks.
  • [New] - Command Line Interface to print reports from terminal or automation scripts.
  • [Fix] 7363 - Improvements for dialog Create Link
  • [Fix] 7501 - Tool - Data Transfer
  • [Fix] 7547 - [ODBC] The name of fields list is 'Tables'
  • [Fix] 7548 - [ODBC] Generate SQL → Create produces broken SQL
  • [Fix] 7550 - [ODBC] Application crashes on execute query
  • [Fix] 7551 - The data transfer does nothing

New in Valentina Studio 6.3.4 (Feb 29, 2016)

  • [Imp][Data Editor] - for mySQL now is used approximated record count for tables with recs count > 1000. MySQL have problem os very slow counting of recIDs for big tables (up to minutes).
  • [Imp] - Notification window now stay on screen if you resize main window
  • [Fix] 7508 - Delete All Records… Menu option broken on PostgreSQL when working with non-public schema
  • [Fix] 7539 - Dialog Create View - SQL preview tab is empty

New in Valentina Studio 6.3.3 (Feb 29, 2016)

  • [Imp][MySQL] - now can reconnect automatically to mySQL without closing windows.
  • [Imp][MySQL] - Allowed to cancel dump task during schema reading.
  • [Imp][MySQL] - Show new types: geometry, geometrycollection, json, linestring, multipoint, multilinestring, multipolygon, point, polygon.
  • [Imp][SQL_SEARCH] - fixed few issues in this new feature.
  • [Imp][DataEditor] - fixed leak.
  • [Imp] - fixed socket leak if connection did fail.
  • [Fix] 7442 - Save File switched to Save As.
  • [Fix] 7503 - after loading dump the schemas are missing.
  • [Fix] 7504 - [MSSQL] Incorrect value of field length.

New in Valentina Studio 6.3.2 (Feb 19, 2016)

  • [Imp][Data Editor] - On big strings was slow. Bug of QT. Improved.
  • [Fix][Bookmarks] - small memory leak.
  • [Fix]7490 - Function Browser non-function using PostgreSQL.
  • [Fix]7493 - Generate SQL: problem with default values.

New in Valentina Studio 6.3 (Feb 15, 2016)

  • [NEW][PRO] - Search of Schema Objects for each supported database.
  • [NEW] - Printing of reports from Print Dialog on each OS: mac, win, linux.
  • [NEW][PostgreSQL][Free] - Schema Editor can work with Domains.
  • [NEW][PostgreSQL][Free] - Schema editor can work with any User Defined Type (UDT).

New in Valentina Studio 6.2 (Dec 14, 2015)

  • [New][Pro] [Dump Dialog] - Now have search field to select group of Tables. This allows you easy set ON/OFF some group of tables with similar name.
  • [New][!!] [Schema Editor] - Support notification channels for Valentina and PostgreSQL.
  • [New][!!] [Schema Editor] - Ability to change fields sort order.
  • [New] [Schema Editor] - Shows all events on a Valentina Server under connection.
  • [New] [Schema Editor] - Event Dialog now have a special calendar popup, which simplifies scheduling an event for specific date and time.
  • [New] [Error Lookup Dialog] for Valentina and SQL Server.
  • [New] [Data Editor] - Keep a new row in buffer, don't add it immediately to the table, so sequence based fields get correct values.
  • [New] [Load Dump Wizard] - Shows errors for Valentina.
  • [New] [Tutorial] - Learn how to generate a Valentina report and send it via email on a schedule.
  • [Fix] [Data Transfer] - Transfer of BLOB value.

New in Valentina Studio 6.1.4 (Dec 3, 2015)

  • 7318: close database and delete phisically dangerously close to each other in context menu
  • 7332: There is no able to figure out a build architecture -32 or 64
  • 7342: One-time event with INTERVAL added and PRESERVE option turns into repeating event
  • 7355: When input focus is set to item in list in the Create Table dialog, ESC keypress tries t…
  • 7356: DEL keypress doesn't work in the objects list of the Create Table dialog
  • 7352: Boolean Not Modifiable in List View
  • 7353: Unique and Indexed flags conflict in Create Table dialog [Valentina]
  • 7354: Indexed flag conflicts with PK in Create Table dialog [Valentina]
  • 7357: Renaming an item should not switch a selection
  • 7358: Cardinality list is not updated on switch between link kinds in Create Link dialog
  • 7360: Need to add FKs tab to the Constraints tab of Create Table dialog
  • 7361: Creation of a multiple-column index or unique should not change Indexed and Unique flags fo…
  • 7362: Arrows do not works in the objects list if row is selected but editor has no focus
  • [APPLICATION] Table Editor: small corrections
  • [APPLICATION] Snippets: small refactoring - the prefix was added to the class name
  • [APPLICATION] Update Checker: flush delayed actions before run the dialog to avoid hangs in tests
  • [APPLICATION] Tests: corrections for vsUpdateChecker
  • [MYSQL] Model: corrections (1 test fixed)
  • [MySQL] Field names should be case insensitive
  • [VALENTINA] CreateLink Dialog: corrections for property PROP_LINK_CARDINALITY
  • [FIX CRASH] Use smart pointer to fix use pointer after flush UI
  • [FIX CRASH] Don't use lambda as signal handler (do don't have destroyed 'this'), handle signal in…
  • FIX: [LT] LModelList: ability to navigate through items after ESC was pressed
  • FIX: set Indexed property of a field on creation of a new index, modifying existing
  • FIX: update status bar on next event loop iteration (seems repaint during update can cause XIOError on…
  • FIX: don't process messages from window managed in FlushDelayed function
  • FIX: use parameter to quote identifier

New in Valentina Studio 6.1.1 (Nov 13, 2015)

  • [NEW] Valentina Studio for Windows now have 64 bit version. New archive added to FTP.
  • [NEW] Valentina for Xojo now
  • has 'ValentinaPlugin.xojo_plugin' name
  • use zip format instead old .rbx
  • contains 64-bit versions of plugin for all 3 os.
  • installer now installer both vcomponents and vcomponents_64 folders to your computer. This is temporary, until Xojo IDE is 32-bit itself.
  • [NEW][VNET] Valentina for NET ADK now have classes for:
  • Valentina SQLite Server.
  • Notifications of Valentina Server.
  • [NEW][PHP] now provides PDO driver to access Valentina SQLite Server.

New in Valentina Studio 6.0 (Sep 19, 2015)

  • [NEW][All] - Change from wxWidgets framework to QT. Yet using heavy C++11 features.
  • [NEW][All] - MS SQL database plugin.
  • [NEW][All] - SQLite Client database plugin - to work with [Valentina SQLite Server].
  • [NEW] - SQL Editor now have additional left panel, which show schema objects tree, queries prepared in the Query Builder.

New in Valentina Studio 5.8.8 (Sep 6, 2015)

  • [FIX] - MySQL: added missing processing of the error in multiple statements.
  • [FIX] - MySQL: corrected query to run on MySQL 5.7 with ONLY_FULL_GROUP_BY option enabled.
  • [FIX] - 7142: Fields in CSV file which are empty block import to Postgresql server.

New in Valentina Studio 5.8.6 (Sep 6, 2015)

  • pg_dump updated to latest version.

New in Valentina Studio 5.8.5 (Sep 6, 2015)

  • Introduced universal serial - 1 serial for 3 OS.

New in Valentina Studio 5.8 (Apr 24, 2015)

  • [FIX] - 7043: PostgreSQL 9.4 dumps fail with server version mismatch.

New in Valentina Studio 5.7.5 (Mar 6, 2015)

  • Valentina Kernel:
  • [FIX] - 6956: Phantom Index records on specific field - may cause duplicate record return.
  • [FIX] - 7004: Crash on creating comment for Binary Link in the RAM database.
  • Valentina Server:
  • [FIX] - 7008: Incorrect date time values from SHOW CONNECTIONS statement.
  • Valentina for Xojo:
  • [Imp] - Example projects updated to format of Xojo 2014r4 and specified BUNDLE_ID.
  • [Imp] - Extensions of example projects updated to ”.xojo_binary_project”
  • [Chg] - Removed folder “1.x Examples”, to not confuse new users.
  • [Fix] - Minor corrections in Test example, to compile on latest Xojo. Public scope of few variables was changed to protected.

New in Valentina Studio 5.7.1 (Jan 21, 2015)

  • Valentina Kernel:
  • [Opt] - 7000: Optimize query as: UPDATE tblUSR SET CNT=(SELECT CNT FROM tblCNT WHERE tblCNT.UID=tblUSR.UID).
  • [Fix] - 6987: Function list_nthitem (inList, inItemIndex, delimiter) returns NULL, if inItemIndex> 1.
  • Valentina Server:
  • [Imp] - 6999: Log file now prints version of SSL.
  • Valentina Studio:
  • [Imp] - 6995: Update SQLite engine to 3.8.8.
  • [Fix] - 6985: [ODBC][Windows]SQL editor doesn't show the first record from the result.
  • [Fix] - 6989: [Postgres] VStudio produces an error in logs, if access to 'postgres' db is not granted.
  • Valentina C++ ADK:
  • [Fix] - 6993: Remove TickCount() usage, which belongs to old Carbon API.
  • [Fix] - 6994: Xcode projects - VSDK Examples - should use vcomponents and libs with _x64 suffix.

New in Valentina Studio 5.7 (Jan 6, 2015)

  • Valentina Kernel:
  • [FIX] - 6960: Crash on SQL query with GROUP_CONCAT which worked in the previous versions.
  • [FIX] - 6969: VCursor.Position property return a wrong value under certain circumstances.
  • Valentina Server:
  • [NEW] - 5486: [NEW] Access Control List to allow/disable connections from specific IPs.
  • [FIX] - 2291: Can not perform db.ThrowOut() without open or create db before.
  • [FIX] - 5870: DROP DATABASE for closed database leads to kernel error and has no effect.
  • [FIX] - 6707: Docs about Password security.
  • [FIX] - 6756: Only connections with successful login should be counted..
  • [FIX] - 6966: Extra connection needed for admin only in case of all connections are in use.
  • [FIX] - 6982: Non-PRO VStudio creates a project, which is shown as not registered in SHOW PROJECTS and appears in SHOW DATABASES.
  • Valentina Studio:
  • [FIX] - 6797: Field name underscore prefix is replaced by the space character.
  • [FIX] - 6817: SQL editor doesn't display underscores correctly.
  • [FIX] - 6925: Role delete ('-' button) in Server Admin makes Valentina freeze.
  • [FIX] - 6972: Valentina Studio now supports PostgreSQL Materialized Views.
  • [FIX] - 6974: There is no sync script for collation, working with SQLite.

New in Valentina Studio 5.6 (Oct 17, 2014)

  • VALENTINA KERNEL:
  • [NEW] Hash Indexes:
  • [API] New flag fIndexHashed
  • [API] New Index property isHahed
  • [SQL] Extension of column_constraint clause. Added HASH.
  • [SQL] Extension of command CREATE INDEX index_name ON TABLE [USING (DEFAULT | HASH)] ( column_name, … )
  • [SQL] SHOW INDEXES now shows index_type column.
  • [NEW][Docs] Valentina Database Indexes section.
  • [Imp][Speed] Index optimization that was introduced in the v5.4 (Sept of 2013) improved to affect now Build Index algorithm of types > 4 bytes size, e.g. double, string and VarChar. Speed have go up about 2 times in our bench for string[100] field with 1 million records.
  • VALENTINA STUDIO:
  • [NEW] Support of new Valentina DB index type - HASH INDEX.
  • [NEW] Ability to show simple textual news from Paradigma into top-right message box in Toolbar.
  • [Imp] - 6897: SQL Editor now works better with SQL files: TAB-panel have name of the file; * is shown for dirty files; can be saved by cmd+S into same file.

New in Valentina Studio 5.5.8 (Jun 30, 2014)

  • Valentina Kernel:
  • [New] - 6831: SQL function RAND_REGEXP( pattern, [index] ) to generate random string result following regex pattern.
  • [Imp] - Improved performance of Valentina engine on Windows, thanks to reduce of the number of calls system function FlushToDisk. On Windows, this function is incredible slow. Linear to the number of calls, even if nothing to save to disk. Speed up can be up to x10 for some cases.
  • Valentina Studio:
  • [Fix] - 6840: [ODBC] Errors on connection to databases which support schemas.
  • [Fix] - 6841: UTF8 strings look corrupted in data editor even though table charset is set to utf8.
  • Valentina for Xojo/REALbasic:
  • [Imp] - 5464: Do Diagnose and Reindex in background

New in Valentina Studio 5.5.5 (Apr 11, 2014)

  • Valentina Kernel:
  • [Fix] - 6800: Crash after double ValentinaThreadInit()/ValentinaThreadShutDown() in the same thread.
  • [Fix] - 6814: Empty result of getting Date/Time Separator properties via SQL.
  • Valentina Reports:
  • [Fix] - 6806: Charts not rendered on Windows, if an application is run without administrator privileges.
  • Valentina Studio:
  • [Fix] - 6809: Valentina Studio doesn't show default databases and schemas on PostgreSQL server

New in Valentina Studio 5.5.4 (Mar 13, 2014)

  • Valentina Kernel:
  • [Fix] - 1893: SELECT… WHERE abc = 08 returns incorrect results.
  • [Fix] - 3146: CURRENT_DATE() should be a synonym of CURDATE().
  • [Fix] - 3147: CURRENT_TIME() should be a synonym of CURTIME().
  • [Fix] - 3150: SELECT IFNULL(NOT NULL,1); return error instead of “1”.
  • [Fix] - 3414: current_date() not functioning.
  • [Fix] - 4435: Comparing datetime and date seems to have problems.
  • [Fix] - 4515: Line numbers reporting goes wrong when comments are used.
  • [Fix] - 4722: Kernel does not count comment lines.
  • [Fix] - 4977: conversion string → dates problem.
  • [Fix] - 5551: Field within nested function call in SELECT.
  • [Fix] - 6505: Incorrect line number in the error message for wrong sql query.
  • [Fix] - 6792: Result of searching for “false” values include “null” values as well.
  • [Opt] - 4776: Optimization suggestions for SUBSTR and LOCATE.
  • Valentina Studio:
  • [Fix] - 6763: mysql dumps of Wordpress databases equates to invalid/incomplete dumps.
  • [Fix] - 6775: Summary Fields fails to calculate the correct value.
  • [Fix] - 6779: Schema Editor is not loading PgSQL databases.
  • [Fix] - 6780: Add ability to disable trigger for PostgreSQL using Property Inspector.
  • [Fix] - 6782: database comments are not exported in PostgreSQL 9.1.
  • Valentina Server:
  • [Fix] - 6746: Parser “revoke privileges” syntax must be extended with object type.
  • [Fix] - 6758: Add to log bind parameter values.

New in Valentina Studio 5.5.3 (Jan 30, 2014)

  • Valentina Kernel:
  • [Fix] - 5633: Crash on special SELECT.
  • [Fix] - 5958: SHOW TRIGGERS doesn't works for table.
  • [Fix] - 6657: Zero-length value after SQL-update with select BLOB value from another row.
  • [Fix] - 6727: IdentsCaseSensitive property missed in SHOW PROPERTIES OF DATABASE results
  • [Fix] - 6738: Crash on join using vObjectPtr in case of IndexChanges = False.
  • Valentina Reports:
  • [Fix] - 6749: Map by fields and map by parameters doesn't work for SQLite datasource in some cases.
  • [Fix] - 6752: Map by fields and map by parameters on Date, DateTime fields doesn't work for MySQL and PostgreSQL datasources.
  • Valentina Studio:
  • [Fix] - 6739: SSL is broken for Postgresql connections in Valentina Studio 5.5.2
  • [Fix] - 6742: Set to NULL for TIMESTAMP not works
  • [Fix] - 6753: Fix ungroup controls from menu on a diagram.
  • [Fix] - 6690: Use table links in myisam.
  • Valentina Server:
  • [Fix] - 4587: Log message, if report is not available due to absence of X.
  • [Fix] - 6579: Possible bug on Privilege Setting of Valentina Server.
  • [Fix] - 6747: User-name must be case-insensitive.

New in Valentina Studio 5.5.1 (Dec 23, 2013)

  • Valentina Engine:
  • db.clone working with db files in BE encoding (old Mac OS). Issue was in text fields.
  • Valentina Server:
  • [Imp] AppleScript scripts to stop/run VServer improved to avoid dialog to ask admin password.
  • [Fix][#6665], Linux, SET DATETIMEFORMAT in batch job did not work.
  • [Fix][#6688], Triggers issue with date time format of db.
  • Valentina Studio:
  • [New] Added “Truncate Table…” and “Empty Table…” commands for Tables.
  • [Fix] Reading of exported diagrams.
  • [Fix][postgreSQL] Corrected reading type attributes.
  • [Fix] Corrected condition to show status of VServer on attempt to get SNMP port.
  • VPHP:
  • [Fix] Issues in db_query method.
  • V4REV:
  • [Imp] Method VReport_Destructor now exists.
  • [Fix] Specific issue in V4REV Linux.
  • [Fix] Install.rev file added into linux installer.
  • VODBC Driver:
  • [Fix] Now able to accept embedded signatures to be able to connect to VServer Embedded.

New in Valentina Studio 5.2.5 Build Jun 8 2013 (Jun 7, 2013)

  • Improved importing data from CSV files, ODBC importing of Visual Fox Pro and Filemaker data
  • Sync tree of databases from the Diagram Editor with a selected database in Columns/Tree View
  • Server administration better reports connection and other errors
  • Improved auto-completion in SQL Editor: show light grey prediction, more info, cmd+. shortcut
  • Improved work with Favorite Queries of SQL Editor. Can be changed order, renamed, changed text, …
  • Improved search in SQL Editor
  • Social media links to Facebook and Twitter for Valentina Studio news