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!
Author: Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
SqlEditor: Improved tooltips
We have write own tooltips, so now they can show even syntax highlight.
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.
SqlEditor: Object Navigation
Now you can do Cmd/Ctrl + Click on the name of any Schema object in the text of query, to open new Tab-panel (or activate existed) with Schema Editor, where this object will be selected.
This feature is available from any place of VStudio, where SQL text is shown!
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.
[NEW] Temporary VIEW and IF NOT EXISTS clause.
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.
4 NEW Video-tutorials for VStudio and Reports.
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.