You can do a self join in R:BASE. You can also have an FK that references a PK in the same table.
But you are right that there is no way to anticipate how many layers deep you may need to go, so you have to have a view or a self join for every possible number of layers. So cursors can reduce the complexity. And R:BASE cannot do the kind of updates that are illustrated in the SQLTeam.com reference. Bill On Thu, Mar 15, 2012 at 1:33 PM, Dan Goldberg <[email protected]> wrote: > The problem is rbase cannot join tables to itself and does not recurse > itself.. That is why you have to use nested cursors. > >
