New Video lessons added:
1) VStudio -> Import via ODBC datasource.
2) VStudio Pro -> Reports -> Grouping
3) VStudio Pro -> Reports -> Controls -> Picture Field
4) VStudio Pro -> Reports -> Regions -> Report Header
Improved AppleScripts on MAC to start/stop VServer.
Now scripts show dialog to ask for ADMIN password, and execute load/unload of a VSERVER under SUDO.
Default parameters for Stored Procedures.
We have add into v4.3 support of default parameters for stored procedures.
CREATE PROCEDURE( IN param INT = 2 ) …
‘OR REPLACE’ Warning. ALTER VIEW Added.
Most Valentina SQL commands of kind CREATE SOMETHING have clause ‘OR REPLACE’. You should understand that this clause forces DROP of existed object before new will be created. This means that all its sub-objects also will be deleted. To avoid this use ALTER command.
For 4.3 we have add ALTER VIEW command.
FIXED Snow Leopard issue in VSERVR’s Sheduler.
Thorsten have found that on Snow Leopard VServer crashes if scheduler is enabled.
Problem was in ICU ucal_open() method. It looks that something was changed in the ICU used by 10.6. Now they require 3d parameter LocalName.
FIXED.
Two new Video Tutorials about ODBC datasource setup.
We have add 2 news video tutorials EN. One for MAC and one for WIN about how to setup ODBC datasource around Valentina ODBC driver.
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:video
These lessons can be helpful to setup ODBC data source for other dbs also, e.g. MySQL or MS Access, if you want import from then into Valentina using
Valentina Studio ODBC data import.
And lesson about this import from ODBC is our next lesson, which is in the work.
3 New Video Tutorials added to VStudio PRO about Reports.
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro
Here you can find new and improved video tutorials:
* Preview Overview
* SubReports
* Formatting
* Expression Field
New lessons now come in two languages English and Russian.
Valentina for iPhone becomes free for use with release 4.2!
With 4.2 release we make Valentina for iPhone (iV4CC), which currently is VClient only, totally free for download and use. Of course you should have a license of a Valentina Server.
Note, that now you can easy download iV4CC and VServer Office archive with DEMO license, develop and test application on both Simulator and iPhone Device.
Report Editor get new control – Page Break
You can use this control to force page break for a report.
Project window have new “Import Local/Remote Project” buttons
These buttons allow you easy import local project to a remote Valentina Server, and visa versa – remote project to local HDD.
Idea is simple: you choose local project, then vstudio create on a selected VSERVER a new project, and execute INSERTs record by record from your local project’s table. As result, you get on the VSERVER a new project with all the same items, which already registered and ready for use.
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, …).
Report Editor get feature Conditional Formatting
This feature allows you to specify for a selected item different styles of formatting (bold,color, …) depending on condition, for example, if f1 > 0 color is black, else it is red and bold.
You can use any valid Valentina SQL expression in the condition.
Report Editor get “keep together” option for Group Header
This option allows you make sure that if there is no enough space at bottom of page then group header is printed on the next page with its records.
Report Editor get Copy Style feature
You can now copy style from one element of report to another using tool bar button.
Report Editor now supports ORDER of items.
Igor have implement ORDER of items feature.
This allows you to have two or more overlapped objects and control their order of draw using commands
* Send To Back
* Send To Front
You can find these commands as buttons in the Toolbar, as menu commands and as keyboard shortcuts.