Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MS Treeview
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00784606
Message ID:
00784909
Views:
25
>Hi,
>I am working on a treeview to display bills of material in a hierachial way.
>All works fine until a part is encountered which is used multiple times on the BOM. It is then not a unique key
>
>How are other folks getting around that problem??
>

I use a prefix, then the PK, then a unique character string. For example,

lcNodeKey = "A_" + TRANSFORM(pk) + "_" + SYS(2015)

Now it's easy to get the PK, just extract out everything between the first two underscores. The prefix identifies the node "type" (usually an identifier for the table).
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Reply
Map
View

Click here to load this message in the networking platform