Softpedia >Mac >Internet Utilities >Valentina Studio >  Changelog

Valentina Studio Changelog

What's new in Valentina Studio 13.10

Apr 15, 2024
  • Valentina Report Engine:
  • [Chg][Controls] - ID and Link properties of a Report Control now are expressions (SQL/JS/Python)
  • [Imp][Groups] - We can now disable sorting for a Report Group using the Original order option.
  • [New][Parts] - Report Part now has a new property 'evaluation_time' which can be one of { First Pass / Second Pass }.
  • We need a deferred generation of the part with TOC at the beginning of the Report.
  • [New][Controls] - Text Controls now have the 'fill_with' property, to fill space by repeating a character or a string.
  • Works for alignments: Left, Center, Right.
  • This is required to fill TOC with standard “……” symbols.
  • [New][Controls] - A justified type of alignment has been added for text controls.
  • [New][Scripting] properties of 'Instance' in the report scripts:
  • Instance.page – a page number where an instance is placed
  • Instance.cursorPosition – a record number an instance is generated for
  • Instance.id – a unique identifier (updates each report generation)
  • [New][Scripting] Report methods to find instances of controls of the specified names:
  • instances() – This method returns general information about instances.
  • instancesForContents() – This method returns only the information necessary for building the table of contents.
  • [New][Scripting] - Report properties to access the main report and child parts:
  • report.parts
  • report.mainReport
  • [New][Scripting] - the ability to use Lazy values in the script to generate Cursor with data.
  • [New][Scripting] - If the script for Cursor returns a sequence with objects, then fields for Cursor will be generated from the properties of those objects.
  • [New][Scripting] - If a control has 'evaluation_time' = Report, then its script gets the original Cursor position, but not the last.
  • [New][Wiki] - page about TOC Generation
  • [New][Video] - Youtube Video
  • Valentina Studio:
  • [New][Report Editor] - Automatic assignment of 'evaluation_time' to 'Report', when this makes sense, e.g. for page number, fields with instances.
  • [New][Report Editor] - Now, you can reorder the parts of the report by dragging their tabs.
  • [New][Report Editor] - Rename part by double click on its name at the bottom.
  • [New][Report Editor] - Added an ability to delete the first part of the report.
  • [Imp][Report Editor] - Display a clear message when a query fails during report generation from an MS SQL datasource. This will assist users in identifying and resolving issues more effectively.
  • [Imp][Form Editor] - The report.takeLogs() method has been added to obtain diagnostic information about report generation when initiated from forms or scripts.
  • Valentina Report Server:
  • Is affected by all changes listed above.
  • Valentina Report ADK:
  • Is affected by all changes listed above.

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.9 (Feb 14, 2024)

  • [New][PRO] - 'VIRTUAL LINKS' by Rules.
  • Useful for databases where ForeignKey-links between tables are not used for some reason.
  • In the SchemaEditor, a database contextual menu now has a 'Manage Virtual Links' item.
  • In the dialog, you can choose from 2 pre-defined Rules, or create your own Rule. Few rules can work simultaneously.
  • Rule allows for Valentina Studio to recognize even hundreds of such 'Virtual Links' automatically.
  • Virtual Links are NOT saved into the schema of a database.
  • Virtual Links start to play in all places where a normal link can be used and this makes sense.
  • Schema Editor
  • Data Editor
  • Diagrams
  • SQL's Autocompletion
  • [New][Wiki] - about Virtual Links

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 19, 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 4, 2024)

  • Valentina Studio:
  • [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.
  • Valentina .NET:
  • [Imp] - Example projects updated to have Target to .Net Framework 4.8

New in Valentina Studio 13.7 (Dec 20, 2023)

  • [New][Win] - crash-logs now are in human-readable format thanks to C++23.
  • [Imp][SQLITE PLUGIN] - Use ALTER TABLE to rename columns.
  • [Fix]9297 - In the Object Inspector, the “Temporary” checkbox does not correspond to an actual table property.
  • [New][JS] - Added 'fetch' and 'fetchSynced' functions to JavaScript.

New in Valentina Studio 13.6.1 (Dec 6, 2023)

  • Valentina Studio:
  • [Imp][MAS][SQLite] - added check in SQLite Connection Handler if location is accessible for sandbox
  • [Imp][MAS][SSH] - Check and ask to add a folder with SSH key to “Allowed Locations”
  • [Imp][SSH] - When adding a private key to establish an SSH connection, open “~/.ssh” folder by default.
  • [Fix][PROJECT PLUGIN] - Fix opening of server projects. (was broken in 13.6.0 by latest changes).
  • [Fix]9292 - VStudio 13.6 Crash when trying to create a copy (duplicate) of a table.
  • Valentina DB:
  • [Fix]9293 - Join against different databases using ObjectPtr produce wrong results
  • [Fix]9294 - ObjectPtr link may be wrongfully chosen for join based on ObjectPtr field type only

New in Valentina Studio 13.6 (Nov 28, 2023)

  • Linux:
  • Update libssh2 on linux to 1.11
  • 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.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.1 (Nov 10, 2023)

  • Valentina Studio:
  • [Imp][Mac] - UPDATED LIBS: SSH to 1.11.1, OpenSSL to 1.1.1w, CURL to 8.4
  • [Imp][Win Intel] - UPDATED LIBS: SSH to 1.11.1, OpenSSL to 1.1.1w, CURL to 8.4
  • [Imp][Win][Mac] - Updated PostgreSQL Client library and dump utility to 16.0.
  • [Fix][Start Page][Win] - Crash sometimes during load and opening of Project Examples.
  • [Fix][Start Page][Mac] - Crash sometimes during load and opening of Project Examples.
  • [Fix][Mac] - sending crash-logs. Was need newer SSL library.
  • [Fix][SQLDiff] - crash on showing found differences.
  • [Fix][GUI][SCHEMA EDITOR] - don't use whole space on show long text in bottom pane.
  • [Fix][Diagrams] - Fixed saving diagram with non-English language chosen in the Preferences.
  • Valentina DB:
  • [Fix]9280 - Mail's Message-ID should be unique

New in Valentina Studio 13.5 (Oct 9, 2023)

  • Valentina Reports:
  • [New] Reports for MongoDB.
  • [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.
  • [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.
  • 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 23, 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 6, 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 “” 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.3 (May 22, 2023)

  • Valentina Studio:
  • [New][Tips] - VStudio now can teach you a little about its features.
  • Tips can be displayed at the start of vstudio (good for beginners)
  • Or you can find them in the HELP menu.
  • Tips are grouped by categories and you can select which to display.
  • [Imp][Schema Editor] - Now when you connect to a DB Server and see a list of databases, no need to double-click a database to open it, because VStudio considers all databases always opened.
  • [Imp][Schema Editor] - Column View:
  • On the right side of the column header you can see the counter now.
  • For Databases/Schemas you can see now 2 counters to easily understand how many objects are hidden.
  • Each column now has “dynamic” buttons, which are shown only when the mouse cursor is moved near to column header.
  • Different columns may have different sets of buttons.
  • Button “+” allows opens dialog to create object of the corresponding type.
  • Button “Search” - displays the SEARCH-FILTER in the column header.
  • Button “Options” - displays a dialog where you can choose which Database/Schema to display and which to hide.
  • [Imp][Data Editor] - Improved the speed in x3-x4 times overall …
  • Especially for DateTime values.
  • [Fix][Query Editor]9211 - After dragging a table from the related tables list to the Query Editor scene the table control is duplicated.
  • [Fix][Dump][MySQL] - When option enabled: “Surround the INSERT statements with statements to disable and enable keys”.
  • Valentina Server:
  • [New] - Sending UDP using new SQL command (non-standard).

New in Valentina Studio 13.2 (Apr 18, 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.1 (Mar 17, 2023)

  • Valentina Studio:
  • [New] - a Report now can have WaterMark. It can be text or picture.
  • new option for Report in the Inspector.
  • [New][Form Editor] - Allow to set custom titles for table view.
  • [Imp][Form Editor] - Notify about changed selection on reset a table view
  • [Imp][SSH][Win] - Updated libssh2 to 1.10.1. It supports connections with an old RSA key to a newer OpenSSH server (shipped with Ubuntu 22).
  • [Fix][Data Editor] - Fixed adding a new record in some cases.
  • [Fix]9189 - Snippets no longer in alphabetical order.

New in Valentina Studio 13.0.3 (Mar 5, 2023)

  • [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 13.0.2 (Mar 5, 2023)

  • [New][Data Editor] Ability to show the current range with a pop-up menu to move between data pages, even with huge tables (up to 100 million records).
  • [Fix][Diagram Editor][Windows]drawing issues for some monitors
  • [Fix][Data Transfer] - Show connections improvements.
  • [Fix][SQLITE] Updating of the 'Indexed' flag when using quoted identifiers.
  • [Imp][SQLITE] Optimize generated queries to add indexes.

New in Valentina Studio 13.0.1 (Mar 5, 2023)

  • Improved stability

New in Valentina Studio 13.0 (Feb 14, 2023)

  • [New][Workspace][Pro] - Workspaces save the states of of opened Editors and will restore them the next time Valentina Studio Pro starts.
  • This includes the automatic re-opening of connections and databases.
  • [New][Diagram Editor][Mongo] - You can draw diagrams for Mongo DB.
  • [Imp][Start Page] - Bookmarks are automatically sorted by name.
  • [Imp][Tree Mode] - Filters in tree mode are much faster.
  • [Imp][Tree Mode][Mongo] - In Schema Editor Tree and in the SQL Editor Tree, MongoDB displays right after the Connections. The 'Databases' sub-level is removed.
  • [Imp][Mongo] - After a connection is established, a database on a Mongo Server is automatically in an opened state. There is no need for an additional double-click.
  • [Imp] - Internal classes of models have been rewritten based on issues reported by way of submitted crash logs.

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 9.1.1 (Apr 5, 2019)

  • [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][Form Editor] Allow sorting records, added methods: addSort(), removeSort(), applySorts(), clearSorts() (9.1.1)
  • [New][Form Editor] Add templates of JS code to sort records (9.1.1)
  • [New][Form Editor] Allow to setup sorting via Property Inspector (9.1.1)
  • [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] Updated UI icons
  • [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][Data Transfer] Transfer of database with schemas (9.1.1)
  • [Fix][Schema Editor] Resize columns of a table with properties in the tree mode (9.1.1)
  • [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
  • [Fix] 8475 Need to limit auto width of columns to parent table width (9.1.1)
  • [Fix] 8498 F5 does not refresh Data Editor (9.1.1)

New in Valentina Studio 9.0.7 (Mar 6, 2019)

  • New:
  • [Project Window] Now has an icon and list view for project items, additionally to the table view.
  • [Project Window] Now shows a preview of reports, forms, queries.
  • [Form Editor] Allowed to use aliases in ComboBox and ListView, allowed to use the script as source data.
  • [Form Editor] Allowed filling lists from a query.
  • [SQL Editor] Static Analyzer errors indicator.
  • [SQL Editor] Static Analyzer console panel where you can see all errors found by the analyzer.
  • [SQL Editor] has menu Default Schemas for PostgreSQL and SQL Server. This allows you to see which schema is currently the default and allows you to change it.
  • [Schema Editor] Ability to create events for Valentina Studio Projects.
  • [Valentina DB] Arrays in stored procedures
  • Improvements:
  • [Schema Editor] Improved speed of the data preview in Schema Editor tree view mode for tables with large BLOB values.
  • [Schema Editor] Fixed slow horizontal scrolling in the Column View
  • [Report Editor] Value for a parameter in the subreport query now is taken from the main report if it is not defined, for example, in the map of parameters.
  • [SQLite] SQLite engine upgraded to 3.26
  • Fixes:
  • [Data Editor] Fix for Image Editor to show a picture from the correct record
  • [Data Editor] Fixed duplicating records with BLOB values.
  • [PostgreSQL] Set sequence default cache value to 1.
  • [PostgreSQL] When adding a new sequence, allow more digits in the “max value” field.

New in Valentina Studio 8.7.1 (Dec 3, 2018)

  • New:
  • [Valentina] Valentina Studio now can connect to Valentina Embedded Server without the special signature.
  • [Diagram Editor] Show/Hide of some FK relations within a diagram
  • [Diagram Editor] Diagram with ALL tables of a database. In the dialog "Add Tables" you can select a checkbox [x] option: Add Existing Tables
  • [Diagram Editor] Drag and drop multiple tables and other objects from the left-side panel to a diagram.
  • [SQL Editor] Drag and drop objects of a schema from the left sidebar of SQL Editor into the edit area. On drop, a dialog appears, where you can choose which command you want to generate and additional options.
  • [SQL Editor][Pro] Underline Not Resolved Identifiers in major SQL commands.
  • [SQL Editor][Pro] "From Code" transformation. Removes quotes and escapes in the text copied from e.g. C# or PHP into SQL Editor, in order to get a clean SQL query ready for execution within Valentina Studio.
  • [SQL Editor][Pro] Execute Current button, which allows executing of only one SQL statement, where the text cursor is located.
  • Improvements:
  • [SQL Editor] Indent/Unindent commands now work from the start of the line, not from the current cursor position.
  • [Valentina] Show encryption key and repeat entry.
  • [Report Editor] Improved report printing for some printer drivers.
  • Fixes:
  • [Diagram Editor] Collapse lists of objects.
  • [Diagram Editor] Fixed wrong query for deleting few child objects
  • [Diagram Editor] Dialog to save diagram's changes on closing the source database
  • [Diagram Editor] Printing diagram as SVG on macOS produces unreadable files
  • [Schema Editor][SQL Server] Schema Editor doesn't display databases on some SQL server instances
  • [Schema Editor][MySQL]Schema editor in tree mode does not show primary key values when PK is multi-column PK
  • [MySQL] Dump from MySQL databases with default string values fails when importing
  • [Valentina] Dump fields of DOUBLE type if they don't have defined scale

New in Valentina Studio 8.6.3 (Oct 24, 2018)

  • [Fix] Minor user interface issues

New in Valentina Studio 8.6.2 (Oct 19, 2018)

  • [New][Report Editor] Region for Last Page Footer
  • Fix][ODBC]8383 Query builder or sql editor with marxmeier ODBC data source

New in Valentina Studio 8.6.1 (Oct 19, 2018)

  • [New][SQL Editor][Pro] Find/Replace now have option ‘In the selection’
  • [Imp][MySQL] – now works with MySQL 8.0 auth connection
  • [Fix]8377 Oblivion Color Scheme selected text is zero contrast
  • [Fix]8380 Resizing of controls works wrong if report is longer than 4096 pixels
  • [Fix]8381 Set the minimum size for dump loading errors page.
  • [Fix]8382 Fixed crash in ON_RParenth() method of Static Analyzer

New in Valentina Studio 8.6 (Oct 19, 2018)

  • Valentina Studio introduces a new Parameters editing feature to the SQL Editor:
  • [New][Sql Editor][Pro] - Ability to work with SQL commands that have BIND - PARAMETERS When typing or pasting a SQL command with bind parameters (?, :n, $n - different for each DB), SQL Static Analyzer recognizes parameters and show them in the new Parameters Panel
  • [New] Specify values for each parameter in Parameters Panel before executing the query
  • [New] Hide / Show Parameters Panel button
  • [New] checkbox “Use Parameters” - allows you to send SQL command that has parameters as a regular command ( e.g. for stored procedures).
  • Other improvements to Valentina Studio include:
  • [Imp][Form Editor][Pro] - now you can select many controls and edit them together.
  • [Imp][Sql Editor] - tab-panel 'Templates' on the left (from the 'Snippets' panel)
  • [Fix][ValentinaDB] Data Editor did not show numeric values for some types.
  • [Fix][Sql Analyzer] func_name() not recognized correctly if func_name matched a keyword

New in Valentina Studio 8.5.5 (Oct 19, 2018)

  • [New] [SQL Editor] Visual toolbar with buttons to do advanced formatting on SQL text

New in Valentina Studio 8.5 (Sep 5, 2018)

  • [New] [Script Editor] The Script Editor, available for all visual controls, now supports JavaScript auto-complete for JavaScript objects and classes (PRO)
  • [New] [Reports from JavaScript Code] Support for VProject and VReport classes makes it possible to script printing of reports from Valentina Forms
  • [New] [SQL Editor] 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
  • [New] [Data Editor] Copy-Paste directly into a table from Microsoft Excel via Clipboard
  • [Imp] [Data Editor] Use of server-side cursors in working with datasources with ValentinaDB now much faster

New in Valentina Studio 8.3.9 (Aug 16, 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 (Aug 7, 2018)

  • [Imp] Added new translations into RU and UA
  • [Fix] 8311 Printing pie charts (on Windows)

New in Valentina Studio 8.3.6 (Jul 17, 2018)

  • [Imp][SchemaSnapshot] Create function snapshot with the schema in the filename, use type names of parameters in the comment to the function definition.
  • [Imp] German translation.
  • [Fix][Diagrams] Draw the links between tables in different schemas.
  • [Fix][Diagrams] Fix to show related tables in the list if they are located in different schemas.
  • [Fix][Diagrams] Ability to create a link between schemas
  • [Fix][PostgreSQL] Fixed link count for schema and table (links between schemas were not counted, also it fixed that these links were missing sometimes).

New in Valentina Studio 8.3.2 (Jun 12, 2018)

  • Adds new controls to Valentina Forms for working with images and hyperlinks, plus additional improvements.
  • Changes:
  • [New][Form Editor] The HyperLink control opens a default browser window with a specified URL or executes a custom script
  • [New][Form Editor] The Image - Field control displays an image stored in the BLOB/Picture field or loaded by the URL stored in the textual field
  • [Fix] 8281 - Excel dump resulting in more rows than the query result

New in Valentina Studio 8.3.1 (Jun 5, 2018)

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

New in Valentina Studio 8.3.0 (May 23, 2018)

  • [New] Now the form can be based on the SQL 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

New in Valentina Studio 8.2.0 (Apr 16, 2018)

  • [New][SQL Editor] Displays progress of export to SQL, with the ability to stop the export
  • [Fix][PostgreSQL] SSL for Postgresql connections in Valentina Studio 8.1
  • [Imp] Select the current date in the calendar of the event editor

New in Valentina Studio 8.1.0 (Mar 14, 2018)

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

New in Valentina Studio 8.0.2 (Feb 26, 2018)

  • [Fix][Form Editor] - fix icon size on Linux with gtk breeze theme

New in Valentina Studio 8.0.1 (Feb 26, 2018)

  • New:
  • [PRO] Valentina Forms - the most requested feature in Valentina Studio
  • [Data Editor] Array Editor to support a new ARRAY field type in Valentina DB.
  • [Data Editor] Editor for text fields now has the SEARCH field for searching inside of the big texts.
  • [SQL Editor] Ability to switch the source connection of the SQL Editor.
  • [Start Page] Show recent local deleted databases and projects with strikeout font.
  • [Start Page] Recent databases and projects can be sorted by date now.
  • [PostgreSQL] Support of Event Trigger.
  • Improvements:
  • [Data Editor] Column has the auto-size contextual menu, and button Auto-Resize similar to SQL Editor.
  • [Diagrams][Schema Editor] Design dialog gets the ability to change the order of children objects in NEW objects.
  • [Report Editor] Now the images are inserted in the original resolution (for the printer, PDF, HTML, SVG).
  • [Report Editor] Now shows the size of fonts in points instead of pixels.
  • [Report Editor] Save and restore the size of the Edit Query dialog.
  • [Report Editor] Fixed showing the image returned by the SQL Server.
  • [SQL Editor] File menu now has a new item "Open File…" for .sql files to open them directly in the SQL Editor.
  • Fixes:
  • [Data Editor] When switching to another table the current filter is removed because it has no sense for another table.
  • [Data Editor] Fixed Data Editor Layout saving for tables in schemas.
  • [Query Editor] Fixed crash when Query Editor is opened for the closed database.
  • [Query Editor] Add the schema name for the tables when generating the JOIN.
  • [Query Editor] Generate JOIN operation when the alias is set for one of the linked tables.
  • [Report Editor] Sorting dialog can set the order for all fields now.
  • [SQL Editor] Table alias auto-completion now shows RecID and OID fields.
  • [SQLite] Table definition parser fixed - underscore is allowed at any place of a non-quoted identifier.
  • [SQLite] Fixed creation of the second foreign key in the SQLite table.
  • [SQLite] Add newly created SQLite link as a child to the table, not only to the database.
  • [SQLite][Data Editor] - Fixed work with big integer values in SQLite table.
  • [PostgreSQL] Fixed Schema Editor hangs on big tables.
  • [PostgreSQL] Fixed reindex action of PostgreSQL table.
  • [PostgreSQL] Fixed error on getting PostgreSQL 10 sequence properties.
  • [PostgreSQL] SQL Dump updated to support all recent releases of PostgreSQL 10.x,
  • [SQL Server][Data Editor] Escape single quotation marks in entered text.

New in Valentina Studio 8.0 (Feb 22, 2018)

  • With the release of Valentina Studio 8 and Valentina Studio Pro 8, Valentina Studio is now capable of delivering an easy to use visual data management front end through the inclusion of Valentina Forms.
  • Valentina Forms Editor. Drag and drop layouts, controls, database objects and widgets to construct forms visually and save into a Valentina Project File
  • JavaScript Based Scripting. All forms objects are fully scriptable with attachable JavaScript methods and custom methods
  • Any Supported Datasource. Valentina Forms work with any supported datasource, much like Valentina Reports, including PostgreSQL, MySQL, MS SQL Server, SQLite and Valentina DB
  • Scripting Documentation. Documentation for all classes, enums, global constants and more for use in JavaScript in Valentina Forms
  • Code Snippets Library. Snippets library for often used code snippets and custom code snippets
  • Array Editor. Also in Valentina Studio 8, the Data Editor includes a special Array Editor in support of the new feature in Valentina DB ADK and Valentina DB Server

New in Valentina Studio 7.5.9 (Feb 12, 2018)

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

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.7 (Dec 29, 2017)

  • [Imp][VDB] Schema Editor now show the size of index.
  • [Fix] 8111 Error on getting PostgreSQL 10 sequence properties.
  • [Fix] 8149 Text Editor does not escape single quotation marks for MS SQL.

New in Valentina Studio 7.5.4 (Nov 16, 2017)

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

New in Valentina Studio 7.5.2 (Oct 30, 2017)

  • [Fix][SQLite] - Parser fixed - underscore is allowed at any place of non-quoted identifier.

New in Valentina Studio 7.5.1 (Oct 21, 2017)

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

New in Valentina Studio 7.5 (Oct 6, 2017)

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

New in Valentina Studio 7.4.3 (Sep 17, 2017)

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

New in Valentina Studio 7.4.2 (Sep 17, 2017)

  • [Fix] 8057 - Fix crash during painting the LButtonFlat on macOS

New in Valentina Studio 7.4.1 (Sep 4, 2017)

  • [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 (Sep 4, 2017)

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

New in Valentina Studio 7.3.4 (Jul 26, 2017)

  • [New][SQL Editor][VDB] - Added Templates of SQL Command: MERGE.
  • [Imp][SQL Editor] - Added side panel tabs tooltips.
  • [Fix][MSSQL] 7963 - Error handling when connection is broken.
  • [Fix][MSSQL] - Fixed saerch of LOCAL SQL Server instances.
  • [Fix][ValentinaDB] 8022 - It is not possible to edit the table in the data editor, if the table contains ENUM fields with localized values.
  • [Fix] 8026 - Fix CRLF line delimiter processing in the Import Wizard.
  • [Fix] 8027 - Ability to set empty text qualifier for CSV import.
  • [Fix] 8032 - Show completion progress in the Import Wizard based on the amount of data read from the file (all dbs except VDB).

New in Valentina Studio 7.3.2 (Jul 11, 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 8, 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 23, 2017)

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

New in Valentina Studio 7.2 (Jun 7, 2017)

  • [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 26, 2017)

  • [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 19, 2017)

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

New in Valentina Studio 7.1.3 (May 15, 2017)

  • Very minor fixes in already made fixes.

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)

  • [Fix] 7960 - False warning on sorting by RecID/OID fields.
  • [New] - Project Tree - filter added to easy find project items.
  • [Imp] - polish of “Show On Disk” in few places.

New in Valentina Studio 7.1 (May 4, 2017)

  • [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.
  • [Imp][Mac] QT updated to 5.7.1, this contains few fixed bugs in QT.

New in Valentina Studio 7.1 Beta 1 (Apr 26, 2017)

  • [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.
  • [Imp][Mac] QT updated to 5.7.1, this contains few fixed bugs in QT.

New in Valentina Studio 7.0.4 (Mar 24, 2017)

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

New in Valentina Studio 7.0.3 (Mar 5, 2017)

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

New in Valentina Studio 7.0.2 (Feb 28, 2017)

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

New in Valentina Studio 7.0.1 (Feb 20, 2017)

  • VReport:
  • [Fix][Mac32] Issue with printing, in fact because of wrong work with tmp files.
  • V4RB:
  • [Fix] str(intNumber) of Xojo can produce string with ASCII encoding. We take this into account now.

New in Valentina Studio 7.0 (Feb 15, 2017)

  • [NEW] Localization to German, Ukrainian, Russian.
  • [NEW] Convertor: SQLiteDB to Valentina DB.
  • [NEW][VDB] Support of KeyValue store in Valentina DB 7.0
  • [NEW][VDB] Support of VARIANT field in Valentina DB 7.0
  • [NEW][SQL Editor] Improved work of auto-completion menu. Now it shows in 2 colors: already typed part (yeallow) and common part (red) for next chars if it exists. In this case press TAB.
  • [NEW][PRO] Ability to modify keyboard shortcuts and create own shortcuts sets.
  • [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. [Read More...]
  • [NEW][PRO] Ability to save the database Schema Cache in file and restore it when you open this database the next time.
  • [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 in Valentina Studio 7.0 Beta 10 (Feb 6, 2017)

  • [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 - 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. [Read More...]
  • [NEW][PRO] Ability to save the database Schema Cache in file and restore it when you open this database the next time.
  • [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 in Valentina Studio 6.6.5 (Dec 9, 2016)

  • [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.5 (Dec 9, 2016)

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

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

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

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

  • [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 22, 2016)

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

New in Valentina Studio 6.5.12 (Sep 5, 2016)

  • [Imp] 7725 Implement auto reconnect if PostgreSQL connection is interrupted.
  • [Imp] 7747 “Create Link” Improved to work with Valentina's DB Binary Link.
  • [Imp] 7748 Restore last selected field type in the [CURRENT] Create Table dialog, reverted previous changes.
  • [Fix] 7750 Renaming a Valentina link in the Property Inspector doesn't work.

New in Valentina Studio 6.5.10 (Aug 18, 2016)

  • [New] Support MS SQL Azure.

New in Valentina Studio 6.5.8 (Jul 6, 2016)

  • [Fix] 7696 Some improvements in SQL Query Editor for retina display. Still some glitches present because of reported QT bug.

New in Valentina Studio 6.5.6 (Jun 2, 2016)

  • Improvements:
  • Upgraded to QT 5.6, this fix few mac-related glitches.
  • [PostgreSQL] Ability to change trigger function in UI
  • [SQLDiff] Various enhancements
  • Fixes:
  • Fixed tool-tips freezing (QT 5.6)
  • Fixed slowness during drag&drop operations (QT 5.6)
  • [Schema Editor] Fixed crash on select a field type in some cases
  • [Report Editor] Fixed showing the values of Decimal fields
  • [Data Editor] Fixed error on filtering by value with single quote
  • [Data Editor] Removed limitation on input of 64-bit integer numbers
  • [SQL Server] Fixed ability to connect to the named instance with dynamic port

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 10, 2016)

  • New:
  • [Report Editor] Report property 'ignore_pagination', which allows you 1) to print endless reports on paper 2) to produce HTML file without page breaks.
  • [Report Editor] Extended options for controlling splitting of the region on the page breaks.
  • [Report Editor] Profiling option to show the reason for a region splitting
  • [Valentina Server] Connection dialog now have a parameter 'Use Notifications'.
  • Improvements:
  • [Report Editor] Allowed to use profiling options in the server project.
  • Fixes:
  • [SQLite] Fixed issue when modifying a table name caused column comments to disappear.
  • [Import Wizard] Fixed CSV import failure in a case, if not all source fields mapped.

New in Valentina Studio 6.5.1 (Apr 29, 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 (Apr 8, 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 (Apr 8, 2016)

  • New:
  • [Report Editor] FREE Report Viewer - ability to preview existing reports and export them to various formats.
  • [Report Editor] A new control Table that allows you to create a grid of data in a report with a few clicks.
  • [Report Editor] Command line interface to print reports from terminal or automation scripts.
  • Fixes:
  • [Data Transfer] Fixed not working transfer if a field mapping was set, but a table mapping wasn't.
  • [Report Editor] Fixed reports generation for MS SQL datasource, if a source query returns Numeric field.
  • [Report Editor] Fixed password request to wrong ODBC datasource, if there are multiple ODBC datasources defined.
  • [MySQL] Fixed crash on showing the list of MySQL databases in Connect Dialog.
  • [MySQL] Fixed non-readable index names after refresh for MySQL server version 5.1.x or older.
  • [MySQL] Show autoincrement field flag in the Property Inspector.
  • [ODBC] Various fixes for ODBC connections.
  • [PostgreSQL] Dump updated to support 9.5.x servers

New in Valentina Studio 6.3.5 (Mar 28, 2016)

  • Improvements:
  • [Export Wizard] Add fields for export by double click
  • [MySQL] Show estimate row count for big MySQL tables
  • [Schema Editor] Close selected databases with single confirmation
  • [SQL Editor] Ability to save modified SQL file back
  • [SQL Editor] Optimizations to handle big files
  • Fixes:
  • [Report Editor] Fixed 'can_grow' flag for fields
  • [Data Editor] Fixed applying a value in the active cell using Apply button
  • [Data Transfer] Fixed Transferring of empty values
  • [Load Dump Wizard] Fixed crash on loading dump to an existing database, initiated from connection
  • [MS SQL] Fixed crash during execution of a big query with simultaneous schema update
  • [MySQL] Fix to change Indexed flag from the Property Inspector for MySQL field
  • [PostgreSQL] Corrections to handle Character Varying PostgreSQL field type, with not specified length
  • [Schema Editor] Fix to show SQL preview in Create View dialog
  • [SQL Search] Fixed a few input focus issues

New in Valentina Studio 6.3.3 (Feb 24, 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. [Read more...]
  • [New][!!] [Schema Editor] - Support notification channels for Valentina and PostgreSQL. [Read more...]
  • [New][!!] [Schema Editor] - Ability to change fields sort order. [Read more...]
  • [New] [Schema Editor] - Shows all events on a Valentina Server under connection. [Read more...]
  • [New] [Schema Editor] - Event Dialog now have a special calendar popup, which simplifies scheduling an event for specific date and time. [Read more...]
  • [New] [Error Lookup Dialog] for Valentina and SQL Server. [Read more...]
  • [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. [Read more...]
  • [New] [Tutorial] - Learn how to generate a Valentina report and send it via email on a schedule. [Read more...]
  • [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.0 (Nov 13, 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][Mac] - VStudio.app now is a 64-bit Cocoa application.
  • [NEW][Mac] - Works standard Cocoa features: full screen, trackpad, …
  • [NEW][Mac] - Support of Retina displays added into many ways. For example, png icons replaced to svg. Algorithms of drawing of reports now take into account scale.
  • [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 7, 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 7, 2015)

  • Fixed trouble with codesign for MAC archives.
  • pg_dump updated to latest version.

New in Valentina Studio 5.8.5 (May 13, 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)

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

New in Valentina Studio 5.7 (Jan 6, 2015)

  • [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.2 (Nov 7, 2014)

  • New:
  • ability to save back the SQL file in the SQL Editor;
  • an option in the Import Wizard to load CSV file inside a single transaction block;
  • support for indexes of hash type in Valentina databases;
  • ability to change a type of index in PostgreSQL databases.
  • Improvements:
  • Import Wizard now shows notification about errors during import;
  • improved adding a record to the related table in the Data Editor;
  • added a preference to show default databases and schemas for PostgreSQL server;
  • added a preference to show default databases for MySQL server;
  • a dialog shown on connection to database server via SSH without defined password (passphrase) now allows to connect with an empty password (passphrase).
  • Fixes:
  • fixed errors on connection to ODBC sources, which support schemas.

New in Valentina Studio 5.6 (Oct 20, 2014)

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

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

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)

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

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.2 (Jan 21, 2014)

  • Fixes:
  • Update list of procedures after adding a new procedure in PostgreSQL database.
  • Improvements:
  • SQL dump of a single table in Valentina database improved to have SET PROPERTY date time on the start of dump;
  • Added support of MySQL and PostgreSQL Valentina Reports datasources via socket file.

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.4.2 (Aug 23, 2013)

  • Data Editor was rewritten to work with huge tables containing millions of records
  • Significant performance improvements with MySQL Servers serving large numbers of databases
  • Ability to set LIMIT and OFFSET in Query Builder
  • Save and load queries for sharing with other Valentina Studio users
  • Ability to work with self recursive tables in Query Builder
  • Works with Putty generated SSL keys
  • Case sensitivity supported in SQL DIFF
  • Improved speed in saving and loading dumps with MySQL, PostgreSQL
  • Add/Edit/Drop Privileges per User or per Schema in PostgreSQL

New in Valentina Studio 5.3 (Jun 28, 2013)

  • New:
  • Now Find/Replace within SQL Results
  • Schema Editor shows groups with Related objects for selection on Diagrams
  • Query Builder can now set an alias for tables
  • Undo/Redo operations for Query Builder
  • Query Builder can use Views to generate queries
  • Directly copy records from tables to CSV or SQL
  • Improved language highlights with PostgreSQL
  • Improvements also added for Reports/Page Footers, Undo in Diagram editing, Duplicating selected records in Data Editor, ODBC with FileMaker DB, mismatching field and other issues with MySQL.

New in Valentina Studio 5.2.5 (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

New in Valentina Studio 5.2.4 (Jun 4, 2013)

  • New:
  • SQL Editor is able to show all results of a few SELECTs, executed at once. Each in separate TAB-panel. Works for SQLite, MySQL and PostgreSQL.
  • Search in SQL Editor result grid.
  • Added JSON format for dumps of databases, tables and results of SQL queries.
  • Show list of built-in extensions for SQLite.
  • Added print_if_empty property for sub-reports in Report Editor.
  • Improvements:
  • Sync tree of databases in Diagram Editor with a selected database in Columns/Tree view mode.
  • Server Admin is working better with errors from connection now.
  • Improved autocompletion in SQL Editor: show light grey prediction, more info, cmd+. shortcut, as in Xcode.
  • Improved work with Favorite Queries of SQL Editor. Can be changed order, renamed, changed text, …
  • Improved search in SQL Editor.
  • Speed of SSH connection improved.
  • Client library for MySQL connections switched from Drizzle to MariaDB.
  • Autoincrement property of a table is shown and can be edited in the Inspector.
  • Dump loading improvements for MySQL, PostgreSQL, SQLite.
  • Bug fixes:
  • Fixed connection to MySQL servers with old-format passwords.
  • Fixed issue, when setting NULL directly into cell of FK field in Data Editor does not hide linked record automatically.
  • Fixed editing of field type in the Inspector of Diagram Editor.
  • Fixed work with Oracle ODBC connection.
  • Fixed work with FileMaker ODBC connection.
  • Fixed crash on change of cardinality of SQLite FK link.
  • Fixed work with Open/Save file dialogs in OS X 10.8.3.

New in Valentina Studio 5.2.3 (May 24, 2013)

  • New:
  • SQL Editor is able to show all results of a few SELECTs, executed at once. Each in separate TAB-panel. Works for SQLite, MySQL and PostgreSQL.
  • Search in SQL Editor result grid.
  • Added JSON format for dumps of databases, tables and results of SQL queries.
  • Show list of built-in extensions for SQLite.
  • Added print_if_empty property for sub-reports in Report Editor.
  • Improvements:
  • Sync tree of databases in Diagram Editor with a selected database in Columns/Tree view mode.
  • Server Admin is working better with errors from connection now.
  • Improved autocompletion in SQL Editor: show light grey prediction, more info, cmd+. shortcut, as in Xcode.
  • Improved work with Favorite Queries of SQL Editor. Can be changed order, renamed, changed text, …
  • Improved search in SQL Editor.
  • Speed of SSH connection improved.
  • Client library for MySQL connections switched from Drizzle to MariaDB.
  • Autoincrement property of a table is shown and can be edited in the Inspector.
  • Dump loading improvements for MySQL, PostgreSQL, SQLite.
  • Bug fixes:
  • Fixed connection to MySQL servers with old-format passwords.
  • Fixed issue, when setting NULL directly into cell of FK field in Data Editor does not hide linked record automatically.
  • Fixed editing of field type in the Inspector of Diagram Editor.
  • Fixed work with Oracle ODBC connection.
  • Fixed work with FileMaker ODBC connection.
  • Fixed crash on change of cardinality of SQLite FK link.
  • Fixed work with Open/Save file dialogs in OS X 10.8.3.

New in Valentina Studio 5.2 (Apr 30, 2013)

  • New JSON format text-based dump of Database, Table and SQL results, as a simple dump or as an Export
  • Execute in the SQL Editor several SELECT queries at once and have the results appear in separate tabs
  • Show a list of all supported SQLite Extensions
  • Improved Favorites - now you can more easily modify, order and change saved Favorite SQL Queries
  • MariaDB Support

New in Valentina Studio 5.1.1 (Apr 5, 2013)

  • Fixed work with local databases in OS X 10.6.
  • Fixed connection to PostgreSQL server by hostname.
  • Fixed creation of reports with datasources on MySQL and PostgreSQL servers.
  • Disabled autosort of columns on export to CSV.
  • Updated SQLite engine to 3.7.16.
  • Improved work with SQLite readonly databases.

New in Valentina Studio 5.0 (Mar 14, 2013)

  • 0005949: [Tool Report Editor] Visual defect in preview of report with subreport.
  • 0006134: [Tool Data Editor] Filtering by numeric filed works not like expected.
  • 0006152: [Other] The table structure remembers the PK constraint after deleting PK field.
  • 0006154: [Tool Schema Editor Diagrams] Objects on diagram becomes invisible after renaming the database file.
  • 0006151: [Tool Schema Editor Tree View] Pressing the button 'Delete' has no effect.
  • 0006156: [Tool Schema Editor] WE need have in the contextual menu of a LINK command DIAGNOSE.
  • 0006143: [Preferences] Crash on closing Preferences dialog (MacOS).
  • 0006135: [Tool Schema Editor Diagrams] Copy/Paste objects on different diagrams works nor properly.
  • 0006121: [Tool Schema Editor Diagrams] The initial area for LABEL control is too big.
  • 0005720: [Tool Data Editor] Filter by cell value.
  • 0006082: [Tool Report Editor] Controls in the properties inspector displays not accurate.
  • 0006108: [Client] Crash on startup in specific instances.
  • 0006136: [Tool Schema Editor Diagrams] Bug on drawing link.
  • 0005908: [Tool Report Editor] Not correct applying of properties through of property inspector, when selected multiple objects.
  • 0006128: [Tool Schema Editor Diagrams] Changes on diagrams not saved.
  • 0006034: [Tool Data Editor] Height of row not changed, if a bottom border is set at border of other row.
  • 0006070: [Dialogs] Properties of fields showed with artifacts in Table Editor.
  • 0006037: [Tool Data Editor] Border between column headers shown only for first columns, that fit on screen.
  • 0006094: [Tool SQL Editor] Improve Console Log with features of multiple selection and keyboard support.
  • 0006044: [Tool Data Editor] Data Editor does not allow to change value of the ObjPtr field.
  • 0006088: [Tool Data Editor] Click on "Revert tables" doesn't hide editor.
  • 0005396: [Tool Schema Editor] Scrolling with the mouse-wheel in table-column is very very slow.
  • 0006036: [Tool Server Admin] Show active connections in server admin, not only bookmarks.
  • 0006072: [Feature] [NEW] Ability to generate query for DELETE/INSERT/UPDATE data for selected table.
  • 0006071: [Tool Report Editor] Not possible to change sorting order of groups in report.
  • 0005975: [Database] Freezing after Idle.
  • 0005618: [Tool Script Editor] Distinction between local and server tabs in sql editor.
  • 0005775: [Tool Report Editor] unknown connection error.
  • 0004354: [Tool Schema Editor Diagrams] Printing Diagram.
  • 0004339: [Tool Schema Editor Diagrams] Hide Diagram links.
  • 0005675: [Preferences] Loses serial number.
  • 0006032: [Tool Data Editor] Set minimum height for the row.
  • 0005907: [Tool Report Editor] There is no possibility to make line with zero width for the border of shape.
  • 0004898: [Tool Start Page] Add databases to start page.
  • 0006068: [Reports Sub-reports] Map Fields to sub-report not working when using ODBC datasource.
  • 0004568: [Tool Data Editor] FILTER: Save filter / "recent filters" menu in Data Editor.
  • 0006061: [Tool Report Editor] Flags 'print' and 'printIf' has no effect for the 'PageBreak' control.
  • 0006043: [Tool Data Editor] Creating of the ObjPtr Link via field property leads to crash.
  • 0006066: [Tool Data Editor] The filtering for the LONG field works incorect.
  • 0006045: [Tool Data Editor] The option [Record ? Interface Options ? Show Methods] has no effect.
  • 0006062: [Tool SQL Editor] vstudio 5.0B54 ctrl + e doens't execute query.
  • 0006069: [Tool Data Editor Related] Set operation AND works not as expected.
  • 0005931: [Other] Visual defect in Schema Editor (columns).
  • 0005951: [Layout] Scrolling with scrollbars in the Report Editor on Windows produces artifacts on screen.
  • 0005966: [Tool Data Editor Related] Postgresql database editor always only shows public schema (5.0 latest beta).
  • 0006002: [PLUGIN DB Valentina Server] The studio crashes after some time of work.
  • 0005033: [Links] Add ObjectPtr to link creation dialog.
  • 0005988: [Property Inspector] Missed Index-by-words checkbox for TEXT field properties in Property inspector.
  • 0005967: [Tool Schema Editor] 5.0b40 Can't open any db on server.
  • 0005955: [Tool Report Editor] Underline is not taken into account when counting height of the controls.
  • 0005952: [Project Tree] VStudio allows to create reports with the same name in different folders.
  • 0005947: [Tool Report Editor] "show on disc" for project item does not work.
  • 0005904: [Tool Report Editor] Ellipse is not exported to html.
  • 0005935: [Windows of Application] FILE -> NEW WINDOW -should open window with START PAGE.
  • 0005936: [Tool Report Editor] Rules do not update area of a selected object if move it by arrow keys.
  • 0005912: [Reports Barcodes] Report does not show barcode label in HTML.
  • 0005924: [Triggers] Selecting Triggers in Schema Editor makes VStudio crash.
  • 0005927: [Tool Schema Editor Column View] Opening a table in the schema editor makes VStudio crash.
  • 0005917: [Reports Controls] Line control has wrong tooltip.
  • 0005913: [Preferences Bookmarks of connections] Deleted bookmark restores after restarting vstudio.
  • 0005905: [Tool Report Editor] Changing of paper size leads to changing margins.
  • 0005902: [Tool Report Editor] Wrong applying coordinates of shape.
  • 0005899: [Reports Controls] Text Field Expression Dialog Misspelled Macros.
  • 0005887: [Drag&Drop] accept *.storedata file when dropped on the app icon.
  • 0005897: [Tool Schema Editor] When connecting to a postgres server, and opening the db, the tables are not showing in schema editor.
  • 0005893: [PLUGIN DB SQL Lite] VStudio does not show triggers, if name of table has different case, than name of the table in trigger definition.
  • 0005794: [Tool Schema Editor] No sql dump option for postgresql db.
  • 0004767: [Other] VStudio Server-DB registration.
  • 0005882: [Tool Schema Editor Tree View] Right click to directory and then click on random place.
  • 0005877: [PLUGIN DB mySQL] There are two "Refresh" buttons in contextual menu for the database.
  • 0005871: [PLUGIN DB mySQL] There is no MySQL option in Connect To Database Server.
  • 0005858: [Preferences Bookmarks of connections] bookmarks show red light even when server is connected.
  • 0005821: Create Function dialog, wrong displaying a list of args.
  • 0005864: [Tool Data Editor Related] Can't relate records in Data Editor Related.
  • 0005865: [Tool Data Editor Related] Can't delete "free" records from the related table.
  • 0005733: [Tool Schema Editor] Ability to physical deleting database without opening it when working with VServer.
  • 0004294: Won't open database on startup.
  • 0005863: [Tool SQL Editor] Can't select query from recent queries if the query is big enough to full all preview space.
  • 0005722: [Database] Database dump should show some progress bar or busy window and notify when finished.
  • 0005726: [Windows of Application] Broken capitalization when copy from DataEditor or SqlEditor.
  • 0005614: [Tool SQL Editor] BS in text.
  • 0005855: [Other] Refresh database takes ages.
  • 0005859: [Database] When trying to CLOSE several DBs at once the incorrect dialog appears.
  • 0005856: [Tool SQL Editor] Recent queries does not work good.
  • 0005527: [Feature] Settings default to a date format which I do not use.
  • 0005800: [Feature] Register Database not something most people know about.
  • 0005828: [Tool Schema Editor] refresh on connection creates an error.
  • 0005818: [Application Menu] adding new field in schema view is difficult.
  • 0005793: [Database] Error message when loading database.
  • 0005810: [Tool SQL Editor] Paste does not work in find-window.
  • 0005797: [Tool SQL Editor] [NEW] Ability to execute selected sql-code.
  • 0005802: [Tool Schema Editor] CMD-A didn't select ALL in length field of varchar in schema editor.
  • 0005565: [Property Inspector] Does not keep the date format updated(Mac 10.6.7).
  • 0005730: [ODBC] Name of DSN connection show as "XXXXXXXXX".
  • 0005762: [SQL] When launching generates a message about an undefined symbol.
  • 0005605: [Tool Server Admin] VServer Admin shows 'old server vesion' text for login time and last activity in connections view.
  • 0005623: [Import/Export] Import imports into wrong database.
  • 0005741: [Links] link 1 with 1,2,3 . and ignoring already linked records.
  • 0004847: [Database] Creation database with empty name.
  • 0005627: [Tool Schema Editor] Cloning makes vstudio crash each time.
  • 0005829: [Tool Schema Editor Diagrams] adding a field to a table in the properties window at the bottom makes vstudio crash.
  • 0004502: [Tool Schema Editor] Implement CHECK interface for fields and tables.
  • 0004677: [Tool Report Editor] Opening a report of a project makes vstudio crash.
  • 0004731: [Dialogs] Columns of a query result cannot be resized.
  • 0004772: [Dialogs] When creating a field in Studio, checking the Primary Key flag will cause problems with other flags.
  • 0004926: [Reports Controls] Changing size and position in inspector not possible anymore.
  • 0004495: [Tool Report Editor] When changing database source in projects you need to change queries and reports.
  • 0004353: [Tool Schema Editor Diagrams] Setting Font and Font Size in Diagrams.
  • 0004358: [Tool Schema Editor Diagrams] Diagrams misbehaving.
  • 0003582: [Tool Schema Editor Diagrams] Need to add 'Generate Change Script' button.
  • 0005499: [Tool Schema Editor Column View] after deletion of a (objectPtr) field I can't add new ones to ANY table.
  • 0004536: [Tool Data Editor] Order in fropdown related table.
  • 0005945: [Tool Report Editor] Copying queries and reports from one project to another leads to strange result.
  • 0005910: [Tool Report Editor] Broke alignment of fields with lage of data.
  • 0003792: [Other]Can not create project on Network folder.
  • 0005763: [Tool SQL Editor] Can't format SQL query using Enter.
  • 0005764: [Tool SQL Editor] Can't navigate on query using arrow keys.
  • 0003965: [Tool Data Editor Related] Working with related records is not possible.

New in Valentina Studio 4.9.1 (Nov 25, 2011)

  • over 100+ improvements to all Valentina products.

New in Valentina Studio 4.9 (Aug 10, 2011)

  • Introduces live Reports previewing, Valentina Reports support for REAL Studio Web Edition, Valentina Client caching of Server-side cursors, and usability improvements for iValentina.

New in Valentina Studio 4.8 (Feb 1, 2011)

  • [Import/Export] Change column size in file preview of import wizard- resolved.
  • [Database] Clone database issue- resolved.
  • [Performance] Move main window on mac- resolved.
  • [Dialogs] Rewrite new Field Dialog using LT
  • [Import/Export] Rewrite export to excel
  • [Other] Replace wxAuiNotebook to LThemedNotebook
  • [Preferences] font selector in preferences visibility issue- resolved.
  • [Schema Editor - Tree View] On select item in tree issue- resolved.
  • [Import/Export] Smart mapping on import - resolved.
  • [Import/Export] Importing to vServer issue- resolved.
  • [Other] vsFramePage inherited from LPanel- resolved.
  • [Links] OnDelete property handler issue- resolved.
  • [SQL Editor] VStudio issue after a Kernel error: 0x60508. Stream EOF reached - resolved.
  • [Inspector] [NEW] Inspector now shows editible CATEGORY and COMMENT for Stored Procedures. - resolved.
  • [SQL Editor] [NEW] SQL Editor can now show the Function Browser dialog with list of all System and User defined procedures and functions.
  • [SQL Editor] [NEW] SQL Editor gets a new menu item to enable Tune/Warnings/Output
  • [SQL Editor] [NEW] SQL Editor gets a new tab-panels for Logs/Output/Warnings/Tune
  • [Other] Issue on diagnose of DB- resolved.
  • [Windows] closing the last tab of a window should close the window itself - resolved.
  • [ODBC Import] Better scrolling/display in ODBC Import dialog - resolved.
  • [Schema Editor - Column View] Code display refreshing- resolved.
  • [SQL Editor] Replace selected text using numeric keypad - resolved.
  • [SQL Editor] DB-popup menu in SQL Editor listing of unopened databases - resolved.
  • [Preferences] [NEW] in the prefs dialog shows PATH to the prefs file and ability open it - resolved.
  • [API] Move vsCursorGrid with all dependencies and parents from SQLPlugin to Application - resolved.
  • [Import/Export] Correctly generate cursor dumps- resolved.
  • [Schema Editor - Column View] multi item selection issues - resolved.
  • [Schema Editor] multi item deletion ... warning issue - resolved.
  • [Dialogs] Dialogs store own size and position on application close - resolved.
  • [Bookmarks] Bonjour items and Bookmarks now display their properties in the Inspector - resolved.
  • [Windows] Resizing of apps work correctly on display change. - resolved.
  • [Contextual Menu] contextual menu and schema menu display issues - resolved.
  • [Schema Editor - Column View] Dropping a method field via right click -> delete... on the field issue - resolved.
  • [Schema Editor] VStudio issue on diagnose db - resolved.
  • [Schema Editor - Column View] Issue while deleting several tables - resolved.
  • [Schema Editor] when closing db issue- resolved.
  • [SQL Editor] SQL editor export issue- resolved.
  • [Import/Export] Export issue to Excel field types when exporting text starting with 0 - resolved.
  • [Import/Export] Export dialog displays columns - resolved.
  • [Import/Export] Export to Excel exports column names - resolved.
  • [SQL] Issue with script execution- resolved.
  • [Keyboard Shortcuts] Mac OS X: CMD-H assignable for hide - resolved.
  • [SQL Editor] Creating a procedure crashes vstudio- resolved.
  • [SQL Editor] Fix error log in the SQL Editor for server connection - resolved.
  • [Schema Editor - Tree View] Treeview on schema editor does not refresh correctly / closing the database makes it temporarily dissappear - resolved.
  • [Schema Editor] SCHEMA editor and PROJECT window display- resolved.
  • [Form Editor] Page break generates an extra empty page at the end of a report - resolved.
  • [Other] Studio error after creating a view - resolved.
  • [Other] Crash when creating a field in Studio - resolved.
  • [Reports - Preview] Switching renderer while in preview to OS native issue - resolved.
  • [Other] Studio issue after creating a table - resolved.
  • [Other] REGISTRATION dialog - resolved
  • [Property Inspector] Renaming a table in Studio does not show the change until you select another table - resolved.
  • [Preferences] VStudio Pro Preferences dialog does not function - resolved
  • [Dialogs] Opening SQL Editor gives error - resolved
  • [Project Tree] deleting datasource from project does not work- resolved
  • [Dialogs] Constraint in listview shows wrong value - resolved
  • [Application Menu] vStudio error when diagnose database - resolved
  • [Property Inspector] properties are not refreshed when clicking on another object - resolved
  • [Property Inspector] Server connection should have more INFO params - resolved
  • [Property Inspector] It should be an ability to turn off index flag on the field without impacting unique one - resolved
  • [Application Menu] Server Menu on opening of Vstudio has command "Server Admin" black - resolved
  • [Import/Export] The order of columns when exporting is NOT shown in the export dialog - resolved
  • [SQL Editor] Exporting from sql resultset - resolved
  • [Property Inspector] Assign property "Size" of the Link in the Property Inspector to the VLinkget_Size() - resolved
  • [Other] Double clicking can cause issues - resolved
  • [NEW][Preferences] Add ability to change colors
  • [TAB-Panels] Shortcuts to walk tab-panel has a problem - resolved
  • [Application Menu] Allow user to change autosave option - resolved
  • [NEW][Application Menu] "Add Report", "Add Folder" in main menu
  • [SQL Editor] text search function in sql editor - resolved
  • [Dialogs] Server connection dialogs differs between ONE or MORE bookmarks - resolved
  • [Schema Editor - Column View] MAc OS X: cmd-a in a field of "create new field" dialog selects ALL tables of the schema view - resolved
  • [Import/Export] Import generates error on mapping columns - resolved
  • [Project Tree - Data Sources] Create Datasource from Bookmarks does not work when not connected before - resolved
  • [Feature] Clicking on the dock icon (Mac OS X 10411) does not open the minimized Valentina Studio - resolved
  • [XML Dump/Load] Unexpected result on load XML dump in client mode - resolved
  • [Import/Export] Import ASCII on mac always produces error dialogs - resolved
  • [Other] when hitting command-s while SplashScreen is open it becomes blocked - resolved
  • [Import/Export] Mac OS X: ESC doesn't cancel (= close) import pane - resolved
  • [Data Editor] MAC command keys consistency - resolved
  • [Other] Saved Window size maybe wrong - resolved
  • [Other] VStudio opens with wrong position on screen - resolved
  • [Performance] Working on remote server database is unusable slow (Ruslan Zasukhin) - resolved
  • [SQL Editor] "Refresh" Button opens new result pane instead of refreshing the active one - resolved
  • [Schema Editor] Refresh button wrong functionality or no functionality - resolved
  • [Database] The cloned database is created in the wrong place - resolved
  • [SQL Editor] "Refreshing" doesn't keep the column width user settings - resolved
  • [Import/Export] crash when closing import wizard through via close BUTTON (bottom left in screen) - resolved
  • [Schema Editor] NOT deleted tables showing up in database list - resolved
  • [SQL Dump/Load] Crash on load database dump to VServer - resolved
  • [Data Editor Related] Removing a filter issue - resolved
  • [Import/Export] Random issue after import - resolved
  • [Views] refreshing with a opened view visible issue - resolved
  • [Printing] Printing Diagram issue VStudio - resolved
  • [Other] VStudio issue when try to open the open dialog - resolved
  • [Import/Export] export wizard doesn't keep order of columns to export - resolved
  • [Dialogs] Clicking in the delete field dialog on the background closes the dialog - resolved
  • [Dialogs] cmd-w doesn't works on text viewer window - resolved
  • [Data Editor Related] removing a filter in upper pane crashes VStudio - resolved
  • [SQL Editor] closing a sql pane issue - resolved
  • [Database]clone and diagnose - resolved
  • [SQL Editor] Editor toolbar can not be controlled by view menu - resolved
  • [Dialogs] Dialog CREATE TRIGGER should have COMMENT field - resolved
  • [Schema Editor] Closing DB issure - resolved
  • [Import/Export] select a file, hit refresh-button issue - resolved
  • [SQL Editor] issue on select statement + hovering mouse - resolved
  • [SQL Editor] Find and Replace functionality in SQL Editor - resolved
  • [Dialogs] selecting multiple db's in open dialog doesn't work - resolved
  • [Schema Editor] Context menu called for some selected objects work only for one - resolved
  • [Schema Editor] Need to correctly set state of edit toolbar items for Schema Editor - resolved
  • [Dialogs] Result window of diagnose must be significantly improved - resolved
  • [Application Menu] Open Recent does not work - resolved
  • [API] View definitions NOT editable or selectable - resolved
  • [Views] View definitions should be editable in VStudio - resolved
  • [API] Remove vs_I_Unknown and fix all child methods (Kirill Pekarov) - resolved
  • [API] Remove duplicated properties for vs_I_ObjectWithProperties - resolved
  • [SQL Editor] Option to enable text wrapping in the Editor(s) - resolved
  • [Schema Editor - Column View] refresh issue if a table is not deletable - resolved
  • [Application Menu] VStudio Recent Menu - resolved
  • [SQL Editor] Shift-End key does not select a line - resolved
  • [Schema Editor] delete table command fails without warning - resolved
  • [Property Inspector] [NEW] - Property Editor Dialog to edit values of object properties without SQL - resolved
  • [Triggers] [NEW] - Dialog to create trigger - resolved
  • [NEW] [Database] Default Mode is now 4 file based
  • [NEW] [Reports Controls] Copy controls from one report to another
  • [Project Window] Project tab toolbar( like in Report Editor )
  • [NEW] [Reports Preview]Render Engine to preview reports
  • [NEW] [Report Editor] Report Inspector has menu > Render Engines
  • [NEW] [Project Tree] Duplicate added to context menu
  • [NEW] [Forms Editor] Splitter between controls panel and editor area
  • [NEW][Report Editor] Added property to label - can_grow
  • [NEW][Report Editor] Console can show detailed timing of report generation, profiling of reports
  • [NEW][GUI] Window Project
  • [NEW][GUI] Report Editor

New in Valentina Studio 4.2 (Jun 26, 2009)

  • Adds a significant, new feature to Valentina SQL, plus several minor features and many customer requested fixes and improvements.

New in Valentina Studio 4.1 (Apr 20, 2009)

  • Adds a significant, new feature to Valentina SQL, plus several minor features and many customer requested fixes and improvements.
  • Valentina 4.1 introduces Recursive SQL operations a feature we believe is original and new to Valentina. We know of no other database that does it.
  • All features in BOLD are new in Valentina 4.1.