michaelkerton
Technical User
Has anyone successfully setup and implemented a DB for ar ecursive search (Bill Of Materials inside a BOM). Is there a 'component' available for delphi?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
setup DB for recursive search 1
- Thread starter michaelkerton
- Start date
- Status
-
1
- #2
You just need to write a bit of code. I have a table of offices where each office has a "parent" office. If I want to know which division or region an office is in, I simply traverse the "parent" chain recursively.
As in all recursive coding, you need to be sure that the recursion will stop eventually. Either be sure the data are absolutely clean (are they ever?) or include a loop counter to limit the process.
As in all recursive coding, you need to be sure that the recursion will stop eventually. Either be sure the data are absolutely clean (are they ever?) or include a loop counter to limit the process.
- Status
Similar threads
- Locked
- Question