Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multilevel must use recursive?
Message
From
06/08/2001 08:36:36
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/08/2001 08:33:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00539221
Message ID:
00540074
Views:
24
>>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

BTW don't let NodeIds misguide you. NodeId would be unique and in fact A01, AA01 etc goes into another field (ie.NodeText, NodeValue, NodeData..). I used them here for NodeIds just for you to follow.
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
Reply
Map
View

Click here to load this message in the networking platform