Switch to: V12V11V10V9V8V7V6V5

Valentina Release 11.2.x Notes

Release 11.2.0


Valentina Studio

  • [New][Data Editor] Now the value editor can be shown in the popup below the edited cell.

  • [New][Data Editor] Added date&time editors (Valentina and MySQL only)

  • [New][Data Editor] Added JSON editor. If JSON content is detected in the text, the editor shows JSON data in two tabs – as a tree and as a highlighted text.

  • [New][Data Editor] Added HTML editor. If HTML content is detected in the value, the editor shows HTML data in two tabs – in a visual editor and in a source editor with highlighting.

  • [New][Data Editor] Added highlighting for cells with JSON content.
  • [New][Data Editor] Added highlighting for cells with HTML content.
  • [Imp][Data Editor] Picture editor now has auto-scaling and drag&drop.
  • [Fix]8923 - SQL dump creates a file that Dump loading will find not valid and create errors.
  • [Fix]8927 - Fix connection to Azure SQL databases.
  • [Fix] - [MySQL][SQL Editor] Don't highlight all words as keywords for the latest versions of the MySQL server.

Valentina Server

  • [Fix]8932 - Client idle timeout might be ignored in some cases.

Release 11.2.1


Valentina Studio

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

Release 11.2.2


Valentina Studio

  • [Fix][Data Editor] - fix detect JSON for blob preview, optimization
  • [Fix][SQLite] - Add brackets if the field DEFAULT value is an expression. Fixes DateTime('now') default.

Valentina DB

  • [Fix]8933 - diagnose improvements. The source of the issue is a UTF16BE storage encoding. Now Diagnose also prints info about encoding.

Release 11.2.3


Valentina Studio

  • [New] - 'Xcode Dark' theme for SQL Editor, use it by default for dark palettes.
  • [Imp] - change selection background in Oblivion theme.
  • [New] - use styled tooltip for links.
  • [New] - warn about broken ObjectPtr-link in tooltip (e.g target table is not defined yet).
  • [New] - [SQL Editor] Shows the number of hidden snippets.
  • [Imp] - auto-remove field from PK on clear the unique flag in 'Design' dialog.
  • [Imp] - Now when you remove the UNIQUE / INDEXED flag in the Inspector, flag PK will be removed automatically (after confirming dialog).
  • [Fix][SQL Editor][Postgres] - Fixed crash on showing the tooltip for the field of result.
  • [Fix]8938 Postgres logs are not readable in the dark theme.

Valentina Reports

  • [Fix] remove space from empty (not hidden) subreport with 'remove_empty_line' flag

Release 11.2.4


Valentina Studio

  • [New][Schema Editor][Valentina] Show Link Count property for links with the number of established relations between rows of linked tables.
  • [Imp][Report Editor][Form Editor] Use custom print dialog on Windows in report preview and VReport.showPrintDialog JavaScript method to allow setting the print range.
  • [Fix][Data Editor] Fixed showing marks for linked records in show all mode of the related table view.

Valentina Reports

  • Changes to positioning types of report controls:
    • [New] Float In Group – this position type allows the report engine to remove empty space between grouped controls if some controls were hidden with the remove_empty_line option.
    • [New] Fixed Relative To Bottom – with this option the control position is fixed and calculated relatively to the bottom controls.
    • [Chg] Fixed Relative To Top – previously called Fixed, with this option the control position is fixed and calculated relatively to the top controls.

Float In Group Example

Valentina DB

  • [Imp] - Improved a lot of speed of SQL command LINK RECORDS, for 1:M Binary Link.
  • [Fix] - VLink.get_Count() right after db.open() could give zero instead of correct value.

Release 11.2.5


Valentina Studio

  • [New][MSSQL] Specialized Data Editors for MS SQL:
    • Date, DateTime, DateTime2, DateTimeOffset, SmallDateTime, Time
    • Binary, VarBinary
    • Image
    • UniqueIdentifier
    • SQL_Variant

  • [New][MSSQL] Supported RowVersion field type.
  • [Fix][Schema Editor] Fixed delay after applying the schema changes – don't wait for internal tasks to finish.
  • [Fix][SQL Editor] Fixed positioning the autocompletion menu on the secondary display.
  • [Fix][Data Editor][PostgreSQL] 8887 Fixed error when loading related PostgreSQL table which has a JSON column.
  • [Fix][Data Editor][MSSQL] 8948 Fixed showing NULL values in the table data.
  • [Fix][PostgreSQL] 8942 Fixed generation of the query to create an index – supported INCLUDE clause.
  • [Fix][VDB] Fixed restoring date and time separators in local prefs.
  • [Fix][MySQL]
    • Fixed reading NULL default values in the column definition.
    • Fixed showing NULL values in result of the query.
    • Restored “Float” field type, removed “Real”.

Valentina DB

  • [Fix] Critical bug for page files with millions of pages. The update is recommended for users with potentially big Tables/Links/Indexes (hundreds of millions of records).

Valentina for Xojo

  • [Imp] Updated macOS deployment script – added an ability to specify individual vcomponent libraries to copy to the app (kernel, vclient, report)
  • [Imp] deployment scripts added into the installer of V4RB
    • So you can easily call from a command line, OR use from a Xojo post-build script.

Release 11.2.6


Valentina Studio

  • [Fix][Schema Editor][Valentina] Don't show Enum/Enum8/Enum16 in the list of field types.
  • [Fix][Data Editor][Valentina] Fixed reading limited BLOB value.
  • [Opt][Data Editor] Don't sort records by RowID for Valentina DB
  • [Fix][Forms] for custom processing of the double click in the table view in form - check if a table value can be edited depending on the editTriggers
  • [Fix][MSSQL] Fixed generating create a query for the float field (there is no dedicated precision and scale).
    • There are only two precision gradations, 24 and 53 mantissa bits, and float(24) is represented as real, float(53) is equal to float, so it is meaningless to have a separate precision property.

Valentina DB

  • [Fix]8956 LINK RECORD( SELECT :1 )… throws an error as no binding value defined
  • [Fix]8960 Compound indexes stays untouched after Table.Truncate()

Valentina PHP

  • [Fix][VPHP] On Linux, copy PHP 8 libraries to package, added build for ARM.

Release 11.2.7


Valentina Studio

  • [New][Forms] Allowed to set from/to parameters programmatically for printing using Windows default print dialog.
  • [Imp][MSSQL] FreeTDS on Windows updated to 1.2.21 to fix showing the error messages.
  • [Imp][MSSQL] Updated automatic discovery dialog, added explanations.
  • [Imp][MSSQL] Added hints on how to fix SQL Server failed connection
  • [Imp][MSSQL] Improved placeholder and tooltip for the host (it can contain the instance name, it was not clear).
  • [Chg][MSSQL] Changes for auto-discover dialog.
  • [Chg][MSSQL] Removed “Server:” field from the connect dialog, it wasn't really used
  • [Chg][MSSQL] Disable Port field in the connect dialog if the instance name is specified, added tooltip about it.
  • [Fix][MSSQL] Fixed showing multiple running instances on the same system in the automatic discovery dialog.
  • [Fix][MSSQL] Fixed detecting local server instances.

Valentina DB

  • [Opt]8962 - IMPROVE SPEED of “SELECT COUNT(*) FROM T” commands.
  • [Opt] new MT alg for ArraySet::Init_BySeqN, works x3 times faster of not MT.
  • [Fix] critical bug in PageFile, related to > 4GB files.

Valentina PHP

  • [Fix][Linux] issues caused by a mismatch in DLLs settings during a build.

Release 11.2.8


Valentina Studio

  • [Imp] Restore saved position and size of the dialog always on the current screen (macOS).
  • [Fix][Report Editor] – fixed moving selected in a group control by arrow keys.
  • [Fix][SQL Editor] – fixed position and size of the autocompletion menu if it is close to the right or bottom borders of the screen.
  • [Fix][MS SQL] Fixed error when getting an IP address for a local instance – always use
  • [Fix][PostgreSQL] – Fixed reading error message on non-English Windows OS.

Valentina Reports

  • [New] - Extend 'remove_empty_line' property with new variants: 'In Area', 'In Group', 'Everywhere'.

Valentina Server

  • [Fix]8970 - Deadlock fixed (after attempt to disconnect client on idle timeout).
  • [Fix]8972 - Unable to clone local db if connection to vServer is open