Hi all
I have this table which is displyed as a TreeView and is self-joined. The fields are as under:
iID - Unique ID
iPID - Parent record's ID
cName
cCode - Code field for which this query is about
iSrNo - related to code field
This will have records as below:
1 0 ABC 001 1
2 1 ABCChild1 001001 1
3 1 ABCChild2 001002 2
4 1 ABCChild3 001003 3
5 3 ABCGranChildof2 001002001 1
so on
This code is not a specification, but I felt that it may be required, but then it has it's own processing and management overheads. The reason I had thought this would be necessary is because, I had felt that when I report I can ask for a report based on cCode = "001" or cCode = "001002" and the node and all it's children will come up.
Similarly the iSrNo field is to allow the user to change the display order of the children nodes like for eg. the user wants the ABCChild3 to preceed ABCChild2 then he can change the Sr. No. from 3 to 2 and 2 to 3 (I will modify cCode accordingly on save).
Have I done it right or there are better ways to do and get the same results.
Please advise.