VCursor Now Can UpdateRecord() of JOINs !!!

It is well known that Valentina offers to developer a very reach ADK API (about 1000 methods) in contrast to poor API of most dbs (e.g. near to 25 in mySQL).

One of nice feature is the ability to use VCursor class methods to MODIFY records of ServerSide & ReadWrite cursor. But for years we did have limit here: cursor can be ReadWrite only for single table SELECT. In the release 4.5 we remove this limitation! Now you can do UpdateRecord() and DropRecord() for cursors built over INNER JOIN of N tables!

Continue reading VCursor Now Can UpdateRecord() of JOINs !!!

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/

SqlEditor: work with history of queries is more simple and powerful.

Now SqlEditor shows history of queries not in the menu, but in the same panel of editor. This give us:

* visibility of few lines of query (and tooltip if query has more of 5 lines);
* syntax highlight;
* filter for fast search in the history;
* choice between history of the current database only or full.

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.

Навигация по объектам из SQL Editor

Теперь можно зажать Сtrl( Cmd ) и кликнуть на имени объекта, чтоб открылся редактор схемы( или стал активным уже открытый ) и в нем был выделен этот объект, данная возможность доступна из любого места где показывается текст SQL:

scr1

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.