Re: Updatable views

From: paul c <toledobythesea_at_oohay.ac>
Date: Wed, 07 Dec 2005 23:43:27 GMT
Message-ID: <zsKlf.63512$ki.49493@pd7tw2no>

x wrote:
> "Rick Elbers" <rick.elbers_at_chello.nl> wrote in message
> news:3189p1dlv9qpofqai5nq8v32keao7amiph_at_4ax.com...
>

>>...

>
>

>>My first try is to find hierarchy in de database by finding the
>>absolute parents assigning them level 0. Parents of my table  are
>>considered those relations in which my foreign key doesnt allow
>>DBNull.

It's the plural use of parent that confuses me. By parents does the OP mean rows in a second table that the first table refers to (eg., A refers to B where many A rows refer to one B row), or does he mean rows of several different tables apart from the first table, for example table A refers to B and table B refers to C or even simpler, multiple recursive 'parents' in the same table?

(I'm trying to figure out if the question involves recursion.)

Thanks,
p Received on Wed Dec 07 2005 - 17:43:27 CST