You may set LogToSysLog variable to 1 (in the INI file or via vServer properties) to make vServer put log messages into the system log:
* Event log for Windows
* SysLog for Linux.

The default state of variable is off.

Working with Trevore Devore we have found that V4REV do not understand Binary Values if pass them into array of binds.

Problem is that external get array of MCstrings which contain {char*, len}. So external cannot differ strings from binaries.

Solution is like in REV DB. Developer must use prefix “*b” for array items, which contain binary values.
put 1 into binds[1]
put str into binds[2]
put binaryValue into binds["*b3"]

VREV external now is able to analyze names of array and found binary values.

In some cases we can avoid copying sub-query result to the temporary table. We can even use sub-query cursor “as is” – so it could be used as a result of the whole query. In other words there  is almost zero overhead against a simple query.

For now such optimization can be applied if a query:

1. contains only “*” item in the select list clause
2. has no “where” clause
3. has no “group by” clause
4. has no “having” clause
5. has no “distinct” clause
6. is not a part of some join operation
7. has no “order by” clause
8. has no binding values
9. sub-query is not a “union/except/intersect” result

Examples:

SELECT * FROM (SELECT * FROM t1 WHERE f1 > 5);

SELECT * FROM (SELECT t1.f1, t2 f1 FROM t1 JOIN t2 ON l1 WHERE t1.f1 > 5 AND t2.f1 <3);

I have add ‘preview’ and ‘comment’ properties to diagrams. Also added import and export to context menu.

We have add for VIEWs ability to be temporary, like we allow for Tables, Fields, Links. Temporary objects are not stored in the schema (.vdb file).

Also we have add for consistency IF NOT EXISTS clause to CREATE VIEW command.

New Video lessons added:

VStudio Admin

1) VStudio -> Import via ODBC datasource.

VStudio Pro

2) VStudio Pro -> Reports -> Grouping
3) VStudio Pro -> Reports -> Controls -> Picture Field
4) VStudio Pro -> Reports -> Regions -> Report Header

Now scripts show dialog to ask for ADMIN password, and execute load/unload of a VSERVER under SUDO.

We have add into v4.3 support of default parameters for stored procedures.
CREATE PROCEDURE( IN param INT = 2 ) …

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.

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.