Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multilevel must use recursive?
Message
From
06/08/2001 08:33:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/08/2001 08:14:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00539221
Message ID:
00540073
Views:
15
>Hi,
>Thank you for your sample code and info. Seem, I do it wrongly at the beginning, save data in defined relationship. Could you tell me, how should I define the level?
>
>Ex.
>Item
>A01, B01, C01
>
>Package
>AA01 - A01, B01
>BB01 - AA01, C01
>
>Refer to the case above, What is the level for AA01 and C01?
>
>Thank you

John,
Think as a treeview (or dir listing). You could look above as :
UPPERNODE
  +--BB01
      +--AA01
      |   +---A01
      |   +---B01
      +--C01
Given this for this particular branch data would look like :
NodeId ParentId 
------ --------
BB01   UPPERNODE
AA01   BB01
A01    AA01
B01    AA01
C01    BB01
Notice that with this scheme you can insert any indiviual node under any parentnode just like directories (ie: item 'system' could exist under 'windows' and also say under 'mydir' with all its subdirs or alone or with some of its subdirs).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform