Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find Root+1 parent node in heirarchial table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00956896
Message ID:
00958387
Views:
15
Hi David

Thanks a lot for your help.

>If you need to do full tree traversal you have a couple of options.

Yes, okay.

>One that works very fast if you can constrain the max depth of the tree you can hardwire a number of self joins:

No go.

>Or you can go with a recursive function that just iterates the tree however deep it goes.

Okay.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform