Re: Fetching from a hierarchical data structure?

From: FT <admin_at_idun.adsl.dk>
Date: Tue, 10 Apr 2001 21:33:21 +0200
Message-ID: <9avpj1$21di$1@news.cybercity.dk>

Hi Maury

You are right about the size problem, but the projects where I have used this apporach this has not been a issue. Happy poking :-)

"Maury Markowitz" <maury_at_remove_this.sympatico.ca.invalid> wrote in message news:7CIA6.74586$XV.18661681_at_news3.rdc1.on.home.com...
> "FT" <ft_at_ep-soft.dk> wrote in message
> news:hcAA6.127$X22.1787_at_news.get2net.dk...
> > Hi
> >
> > An alternative approach would be to create a "Key" column. This column
holds
> > a key string made up of Subkey from each level in the hierarchy. IE:
>
> Hmmmm, this is interesting. Ok, I like it. The only problem I see is
that
> the size of the table is then set based on the length of the key, but I'll
> poke around and see what the real limits are.
>
> Maury
>
>
Received on Tue Apr 10 2001 - 14:33:21 CDT