Category: Valentina Studio Pro

[NEW] SQLite plugin for Valentina Studio Pro (!!!)

In v4.8 we introduce PREVIEW of a new Valentina Studio Pro plugin – SQLite. We do this on few reasons:

1) Around Valentina DB exists many IDEs where SQLite is integrated on default. So we have quite often case when Lite developer want switch to Valentina DB.

2) We going to open Valentina Reports to users of other databases also. First of them with be users of SQLite. So it will be comfortable for them to be able use Valentina Studio to design REPORTS, and in the same time manage their SQLite dbs. The second our step will be – to add other dbs (Postgre, MS SQL, ODBC, …) and also integrate them into Valentina Studio, at least via our ODBC plugin.

Continue reading [NEW] SQLite plugin for Valentina Studio Pro (!!!)

vClient becomes thread-safe (!)

Now you should not synch vClient API calls  – vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly.

In particular, vStudio operates with remote connections via multiple threads  and it was a source of some glitches and unexpected errors especially with a long queries.  Now there are no more errors like “EOF reached…” or “Broken packet received…” which were result of incorrect thread synch.

NEW Left Side Bar in Schema Editor of Valentina Studio

We have added the left side bar into Schema Editor.

It looks similar to what have OS X Finder and Windows 7. This sidebar allows you easy jump to the most common and/or recent places of your job. For example, you can by single click open recent database or connection or your bookmark to a Valentina Server. Your login and password can be stored, so no need to retype them each time.

Continue reading NEW Left Side Bar in Schema Editor of Valentina Studio

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.

Project window have new “Import Local/Remote Project” buttons

These buttons allow you easy import local project to a remote Valentina Server, and visa versa – remote project to local HDD.

Idea is simple: you choose local project, then vstudio create on a selected VSERVER a new project, and execute INSERTs record by record from your local project’s table.  As result, you get on the VSERVER a new project with all the same items, which already registered and ready for use.

Report Editor get powerful formatting by pattern

This is a very important feature for reports. And we have implement it using the same internal engine as the Valentina SQL format() function.

You can read Valentina WIKI: http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#format

For any output field you can specify in the inspector its pattern and kind of pattern (number, currency, …).