Category: Valentina Studio Pro

[NEW] VStudio Pro – SQL DIFF for Valentina, PostgreSQL and SQLite.

Valentina Studio Pro 5.0 going to get great new built-in feature: SQL Diff . This feature allows to open two databases and find difference between them and produce SQL script to resolve this difference.

Today our developer have plug all 3 databases (Valentina, PostgreSQL, SQLite) into SQL Diff and made tests. All 3 databases works as expected.

This is cool to have this feature right in the Valentina Studio, because then no need to purchase separate SQL Diff tools, which self might cost $100-400.

Below you can see few snapshots how looks SQL Diff wizard and SQL Diff Result page.

Continue reading [NEW] VStudio Pro – SQL DIFF for Valentina, PostgreSQL and SQLite.

VStudio:Report Editor – Now works with PostgreSQL as Datasource.

Valentina Studio Pro’s Report Editor now works using a PostgreSQL database specified as datasource! If have some Postgre database, connect to it and start design new report using data of that database. You can instantly preview your data right within Valentina Studio Pro. Reports are saved into a project format so you can reuse them at any time.

You can already use design reports this way from data from any Valentina DB ADK (REALbasic, Revolution, Cocoa, NET, PHP, … ). You can see few snapshots below.

Support for PostgreSQL will be included in Valentina Studio 5.0b1 – coming real soon. Valentina Reports will be able to work with local Valentina databases, Valentina Server hosted databases, local SQLite and now with PostgreSQL server.

Continue reading VStudio:Report Editor – Now works with PostgreSQL as Datasource.

Valentina Reports get ODBC-datasource!

Valentina Reports now support ODBC datasource!

This is great, because now Valentina Reports can work with data stored practically in any database format (MS Access, MS SQL, Oracle, Postgre SQL, mySQL, … ) and even XML.

In Valentina Studio improved datasource dialog to support ODBC.

In a Valentina ADK code, you should specify connection string in the VProject.MakeNewReport( inDataSource ), as the following: odbc://dsn=access,user=name,pass=123

Will be available in the 4.9b5 build or newer.

[VReports][NEW] Improved HTML, Picture Controls

On users request we have made the next major improvements in Valentina Reports:

  • HTML Control now can get HTML text/content from:
    • TEXT typed directly in the control
    • FIELD of cursor
    • by URL from a FIELD of cursor
    • URL (local or remote)
  • Picture Control now can get a picture from:
    • FIELD of cursor
    • URL from a field of cursor
    • URL (local or remote)
  • HTML text can contain a macro $() to, for example, refer another field

You can see details on the following pictures.

Continue reading [VReports][NEW] Improved HTML, Picture Controls

[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