On 4/21/09 6:15 PM, "David Bovill" <david.bov...@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] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution