[ANN] Valentina Studio 2.4.2 b3 introduce Query Builder feature!

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Sep 9 01:22:27 CDT 2006


Hi All,

We are happy introduce you new cool/nice/... Feature/plugin
In Valentina Studio: SQL Query Builder.

To see it, 

* just open any database of v2 version,

* Do right-click on database and in contextual menu
choose "Query Builder" option.

* Builder contains 4 areas:
   - diagram
   - grid
   - SQL query text
   - results of query

* You will be asked add one or more tables into diagram

* Having one or few tables on diagram, you need/can setup links that should
be used in query you want to build.
    
    - on diagram you will see links between choosed tables.

    - You can note, that FOREING KEY-link, ObjectPtr link, and
        BinaryLink are draw in different ways on diagram. So it is
        easy to differ them visually.

    - You can specify for link via contextual menu if you want OUTER join.

    - you can remove a link via contextual menu some of them

    - You can drag from one field of a Table to another field of
        other table to build RELATIONAL link.

    - TODO - add ObjectPtr link by drag and drop
    - TODO - general dialog "Add Link"

* You can specify for a field if it should be SELECTed, SORTed and how.

* You can specify filter conditions that go into WHERE.

* All objects have contextual menu, even fields inside of tables.
   
* on all objects work tool tips.

* you can show/hide any are at any time using tool bar buttons.

* the green check mark button in tool bar allow execute query that you have
build and see result in 4th are at bottom of window.



---------------------------------------------
** TODO **

* In nearest days will be added support of GROUP BY and HAVING

* future, for 2.5 release we will try add support of building even complex
queries on few tables with OUTER JOINS, that allow specify full control over
order of execution.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list