>Hi.,
> I need to write a module that calculate bonus for member in multilevel marketing. It is a tree format. Is it possible to use SQL to do so ? Or only recursive can do it?
>
>Thank you
John,
VFP SQL doesn't seem feasible for it. You could use ADO shaping maybe as it permits hierarchical rowsets like a treeview. However I think you'd make it easier with nonSQL, recursive or nonrecursive approach (when saying nonrecursive I mean ways similar to recursion but not a true recursion - advantage it doesn't use stack and don't fail with nesting limit).
Also consider collecting an indiviual and its branches to a custom object. You could even create a treeview and walk nodes (slow and actually creating the nodes is doing the job itself).
Cetin