Deprecated Convert_1_2() feature.

Also we are dropping Convert_1_2() feature of Valentina engine from 2.0 version to allow developers convert existed v1 databases. If somebody yet need convert v1 database to 2.0 format, he should use at first v4.3 for this task.

This function is removed from all Valentina ADKs and VStudio, DLL of VDK V1 engine  is removed from the vcomponents folder.

V4RB/V4MD Carbon deprecated in v4.5

We have decide to deprecated these two Carbon products in v4.5, which we have developed yet with help of CodeWarrior.

I think for REALbasic developers, this will not a problem, because few years REALbasic is a cocoa application itself, and works with xcode-made plugins.

For Director users, this means that v4.5 of V4MD mac, will not work with Director10, only with D11 and D11.5. If you still use D10, you can use v4.3 of V4MD that can be found here: http://valentina-db.com/download/prev_releases/

Valentina Reports Free in December 2009

Paradigma Software Inc announces a special holiday offer for professional database application developers. All sales of new or upgrades through Paradigma Software of ValentinaADK or Valentina Developer Network includes the associated Valentina Reports module free – up to a $1500 savings on Valentina Developer Network!

Continue reading Valentina Reports Free in December 2009

SqlEditor Improvements

SqlEditor becomes better. Added

* highlight of line with error;
* logs panel works better;
* tooltips that show info about Schema Object;
* code-folding, great when you type procedure or trigger;
* autocompletion menu has icons;
* if TAB panel is not visible, then buttons to execute queries and such, are shown in the sub-panel, so we can still use them.

A Valuable Adobe Director Resource DirectorForums.com to Close

Long time community supporter Martin Schaefer announced in a public letter that he was going to shut down or transform directorforums.com. Directorforums.com and Directorforums.de provides a valuable news and community source for developers that use Adobe Director to produce standalone and web / shockwave based applications. He goes into some greater detail about his background in Director development. Continue reading A Valuable Adobe Director Resource DirectorForums.com to Close

SNMP and Valentina Server

There is a new feature in Valentina Server – SNMP agent.

Currently we support only get() and get_next() SNMP requests for the following oids:
sysDescr(“1.3.6.1.2.1.1.1.0” )
sysUpTime(“1.3.6.1.2.1.1.3.0” )
Not much info but it makes a possibility to monitor vServer over SNMP.

For now, SNMP facilities are available only for Windows.

You should specify SNMP port in the server ini-file (default port is 161, 0 means turn off SNMP agent):

…

[SNMP]
Port_SNMP=161;             SNMP port to listen by VServer.
;                                             0 – do not use a SNMP port.

…

Valentina for Revolution Supports Now “*b” in the SQL Binding.

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.

Internal optimization for views and sub-queries.

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);