We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.
Continue reading NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune
We have write own tooltips, so now they can show even syntax highlight.
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 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.
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!
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
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.