[thelist] [DB Design] Recursive Directory Structure_applyto_pedigree
Russell Griechen
russgri at bellsouth.net
Sat Feb 1 20:12:01 CST 2003
> node further down and expand that"
>
> now here's the question of the moment, feel free to play along at home --
>
> you know the little plus sign you get in the windows explorer folder pane?
> and how you have to click on the little plus sign to get it to explode?
and
> it only explodes one level, right? did you know you can do that, expand
> that folder to show the folders within it, by pressing the plus sign
(either
> above the equals sign, or on your numeric keypad), or, alternatively,
using
> the right and left arrow keys? do you know what the keyboard shortcut is
to
> explode *all* folders to *all* levels?
Talk about exploding nodes...
A drop down lets user select number of generations and the execution shows
the trees being populated...
I have been trying to find the code to execute this MySql
table Dogs:
ID AutoNumber Primary Key
RegName Text
Sex Yes/No
Dame Long Int Indexed, Dups OK
Sire Long Int Indexed, Dups OK
table DogTree:
ID Long Int Primary Key
Generation Long Int
RegName Text
Sex Yes/No
Dame Long Int Indexed, Dups OK
Sire Long Int Indexed, Dups OK
They could have more fields, but the essential data is in
the ID, Dame and Sire fields. The Dame and Sire fields are
foreign keys back to the ID field in the Dogs table itself.
More information about the thelist
mailing list