Valentina DB 4.1 Introduces Groundbreaking SQL Feature

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Apr 21 11:51:23 EDT 2009


On 4/21/09 6:15 PM, "David Bovill" <david.bovill at gmail.com> wrote:

Hi David,

> Great! Couple of questions:
> 
>    1. Do you have a url to point to the syntax for addressing hierarchical
>    data?

Yes.

This is ARICLE "Hierarchical (Recursive) Queries in Valentina SQL", where we
show 

<http://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:recursive_q
uery>


At the end of Article you will find like to SQL Grammar of these new
commands:

<http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:ref
erence:recursive_query_commands>


-----------------------------------------------------------
In short:

NEW COMMANDS looks like this:

vext_recursive_table         -- v4.1
    :   {ANCESTORS | BROTHERS | DESCENDANTS} OF vext_root_objects
        [{TO|ON} LEVEL UINT] USING link_name [WITH {ROOT | ROOTS}]
 
vext_root_objects
    :   UINT
    |   variable_name
    |   ( search_condition )


You can see that this command can search:

DOWN by recursion starting from a given parent record to find its
child-records.
UP by recursion to find parent-records.
WIDE by recursion to find brother-records.

NOTE: a brother of X-record is a record Y, which is child of the same
parent-record.


EXAMPLE:

SELECT * 
FROM (DESCENDANTS OF (RecID = 2) ON LEVEL 1 USING link1)


-- 
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 use-livecode mailing list