For a DB Tree View, I’m trying to show a portion of the tree. Starting at a selected node, I want to show all of the sub nodes underneath the selected one and all the sub nodes for those nodes. An example would be a bill of materials; starting with a main part what are the subassemblies of that part and the subassemblies of those parts and so on. I would like to look at the complete explosion for 1 subassembly.
Right now I build a bunch of views that join from the previous one and then append them all together in a temp table. I’ve done some searching on the internet and found info on a Common Table Expression (CTE), but it doesn’t look like RBase supports that SQL construct. Tried editing a view in RBase using another example, but can’t change the join code. Here is the code I’m trying to implement: SELECT T1.NodeID, T1.NodeText, T1.NodeColumnName, T1.NodeParentID + FROM TreeList T1 INNER JOIN TreeList S ON S.NodeID=T1.NodeParentID + WHERE S.NodeParentID in (SELECT NodeID FROM TreeList + WHERE NodeText = ’XXXXXX’) Tried changing the 1st WHERE to “WHERE EXISTS (SELECT…” and “WHERE IN (SELECT…”; neither worked (got error code 2043). Any and all advice would be appreciated. Stu Hellman [cid:[email protected]]<http://www.qmiusa.com/> Stuart Hellman Software Designer Email: [email protected]<mailto:[email protected]> Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1029 www.qmiusa.com<http://www.qmiusa.com> . ________________________________ This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
