Posted in April 17, 2009 ¬ 5:44 pmh.Ivan Smahin
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 [...]
Read the rest of this entry »
Posted in April 17, 2009 ¬ 4:29 pmh.Ruslan Zasukhin
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 [...]
Read the rest of this entry »
Posted in April 2, 2009 ¬ 1:53 pmh.Ruslan Zasukhin
Here we will grow set of vide tutorials
Read the rest of this entry »
Posted in April 2, 2009 ¬ 1:51 pmh.Ruslan Zasukhin
As result you can show in a report not only picture from DB, but from disk or by any URL.
Read the rest of this entry »
Posted in April 2, 2009 ¬ 1:48 pmh.Ruslan Zasukhin
MakeNewReport(
inIndex as integer,
inDatabase as VDatabase,
inQuery as String = NULL,
inCursorLocation as EVCursorLocation = kClientSide,
inLockType as EVLockType = kReadOnly,
inCursorDirection as EVCursorDirection = kForwardOnly ) as VReport
Starting from 4.1 parameter inQuery can be NULL. [...]
Read the rest of this entry »
Posted in April 2, 2009 ¬ 1:12 pmh.Ruslan Zasukhin
Was found a problem that in a stored procedure the assignment statement do not accept SELECT with LIMIT. This problem is fixed now. So you can have
procname
BEGIN
var = SELECT f1 FROM T WHERE … LIMIT 1
END
Read the rest of this entry »
Posted in March 25, 2009 ¬ 3:19 pmh.Ivan Smahin
There are three new kind of queries specially designed for recursive (hierarchical) tables.
Such kind of tables are widely used. It could be human relationships, threaded forums and anything which might be described as tree-like data.
There are few common SQL ways to operate with such structures but all of them are too far from perfect.
Valentina introduces [...]
Read the rest of this entry »
Posted in March 18, 2009 ¬ 2:50 pmh.Ivan Smahin
Such kind of trigger may be applied to views only. It could be used for insert, update and delete operations as usual.
Example:
CREATE TRIGGER trigger1
INSTEAD OF INSERT ON v1
FOR EACH ROW
BEGIN
INSERT INTO t2 VALUES( 1 );
END ;
“trigger1″ will be fired on attempt to insert record in the view “v1″.
Starting from v 4.1 you may use ‘NEW’ [...]
Read the rest of this entry »
Posted in March 15, 2009 ¬ 3:35 amh.Ruslan Zasukhin
On request of Marc Schmitt, Kirill have improve work with TIFF format.
1) V4MD 4.0 was the single ADK, which did not allow specify format of picture in the VPicture.WriteAs() method. This problem fixed and now its is possible specify format as #kJPG, #kTIFF
2) But Marc did want more: he want to have SEVERAL compression methods [...]
Read the rest of this entry »
Posted in March 14, 2009 ¬ 3:31 amh.Ruslan Zasukhin
Igor have made great job improving speed of reports generation on linux, which uses the FreeType library (instead of wxWidgets+OS like on WIN/MAC). As result, time of report of one developer go down from 3 second to 0.3.
Actually FreeType library can be used on MAC and WIN. Just no big sense because it was much [...]
Read the rest of this entry »