Switch to: V11V10V9V8V7V6V5

Valentina Release 11.4.x Notes

Release 11.4.0

2021-08-04

Valentina Studio

  • [New][SQL Editor][Pro]9000 – Autocomplete now suggests all fields for “SELECT tblAlias.| FROM TBL tblAlis”
  • [New][SQL Editor]8999 – Autocomplete now respect command “CALL procName()”.
  • [New][PostgreSQL] – Show partitioned tables in the Schema Editor (for issue #8866)
  • [New][VDB]9001 – JSON field from Valentina DB integrated.
  • [Imp][SQL Editor] – Autocomplete now filters out symbols better in a SELECT command.
  • [Imp][SSH] – Added more detailed error messages for public-key authentication, with suggestions on how to fix them
  • [Fix][SSHManager] – removed active waiting for SSH (it reduced CPU utilization).
  • [Fix][SQL Editor][MySQL] – getting the list of built-in functions from hosts where MySQL system tables are unavailable due to restricted permissions.
  • [Fix][MySQL]8991 - Can't add row with value of YEAR type in MySQL database

Valentina Server

  • [Fix][Report Server][Linux] – Fixed issues on accessing VDB data sources in some cases.

Valentina Reports

  • [Fix][Windows] – Fixed printing reports hosted on Valentina Server to a local printer from client applications on Windows (without Valentina.Init or Valentina.InitReports calls).
  • [Fix][Windows] – Fixed printing reports in reverse order.

Valentina DB

  • [Imp][Linux] – Now it is not necessary to have aliases in vcomponents folder. Aliases could get lost during the transfer to hosting, now there is no need to recreate them which simplifies deployment.
  • Some fixes.

Release 11.4.1

2021-08-04

Valentina Studio

  • [Fix][Single] - Enabled shortcuts editing in VS Single.

Valentina DB

  • [Fix]8996 - Produce warning on CHANGE of field type in Table which has a View with Trigger, that trigger can be invalid now.
  • [Fix]8997 - Sql-binding like “:0” produce a weird internal error instead of something like “invalid binding position”.

Release 11.4.2

2021-08-24

Valentina Studio

  • [Imp][Diagram Editor] - Managing printing of diagram to pages.
    • Now you can specify the size of the page in mm INSTEAD OF the size of a diagram in pixels.
    • You can specify the number of pages by vertical and horizontal.
    • You can specify page margins

ValentinaDB

  • [Opt] speed of UPSERT improved about 30%.

C++ SDK

  • [New][Example] SqlStatement_Upsert, which is also a kind of a bench.

Release 11.4.3

2021-09-07

Valentina Studio

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

  • [Upd][MAS] - Apple AppeStore version of VStudio updated to 11.4.2

Release 11.4.5

2021-09-20

Valentina Studio

  • [New][Data Editor] – Added currency formatting for float/double/decimal/money fields.

  • [New][PostgreSQL] – Implemented support of METHOD FIELDS (generated columns), which was added in PostgreSQL v12.

  • [New][PostgreSQL] – Implemented support of identity fields.

  • [Fix][MySQL]9014 – Fixed CSV import into MySQL table.

Valentina DB

  • [Imp] – Improved speed of queries with WHERE, ORDER BY, and HAVING clauses if there is a compound index including target fields.

Release 11.4.6

2021-10-08

Valentina DB

  • [Imp][Mac] internal algorithm to find vcomponent DLLs, to get it working e.g. in a Photoshop plugin, which uses ValentinaDB.

Valentina Reports

  • [Imp] Don't limit barcode data length to 256 characters.

Valentina Python

  • [New] prepare() in cursor, which returns function, which accept binding parameters.
    • This is analog of Stmt = db.Prepare( query ) in other languages
conn = valentina.create('./valentina_example_database.vdb')
 
curs = conn.cursor()
stmt = curs.prepare('INSERT INTO mytable(f1, f2) VALUES(?, ?)') 
stmt(1, '')

Release 11.4.7

2021-10-26

Valentina Studio

  • [Imp][PostgreSQL] Updated PostgreSQL client library and dump utilities to version 14.
  • [Fix][Report Editor] Fixed updating the report preview, in some cases, it didn't work as expected.
  • [Fix][Report Editor] Fixed applying the best size for the multiline label.
  • [Fix][Data Editor][PostgreSQL] Fixed editing values of Timestamp With Timezone columns.

Valentina DB

  • [Opt] improved Stmt.Select() for queries over 1 table and 1 unique field. Speed up x10 times.
  • [Opt] overall speed up of engine.

Valentina Python

  • [Imp] Removed explicit linking to Python 3.7 dynamic library, any compatible version can be used now.