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_at_pd7tw2no>
>
>
Date: Wed, 07 Dec 2005 23:43:27 GMT
Message-ID: <zsKlf.63512$ki.49493_at_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 Thu Dec 08 2005 - 00:43:27 CET