Report Editor get powerful formatting by pattern

This is a very important feature for reports. And we have implement it using the same internal engine as the Valentina SQL format() function.

You can read Valentina WIKI: http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format

For any output field you can specify in the inspector its pattern and kind of pattern (number, currency, …).

Valentina SQL get powerful FORMAT() function.

Ivan have add into Valentina engine new very powerful FORMAT() function for SQL.

It provides great ability to convert numbers and date/times into string format.

Please read detailed syntax in the Valentina WIKI:
http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format

The same algorithms will be added in nearest time to Valentina Reports.

Improvements for stored procedures and binded queries

It was a huge improvement to solve the problem with a “second run” in stored procedures and binded queries.  Sometimes there was an incorrect behavior because of “over-prepared” nodes. There was a workaround with “EXECUTE” statement (which is actually developed  to prepare any SQL statement and execute one from another SQL statement). So now this workaround could be omitted.

Valentina for Ruby MAC Improved

We have improved Valentina for Ruby v4 on MAC.

Now we have single UB module vruby_fat_release.dylib instead of two _ppc_ and _i586_. This still perfectly works with Ruby.

The WIKI pages about MAC INSTALL are corrected and updated.

We corrected the Valentina.rb adapter to reflect changes in the SHOW commands in v4, which now produce cursor with columns that have prefix ‘fld_’