Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Database displaying problems
I have the following problem. I have a self referencing table(table that points to itself). This structure is implemeted so that so that I can model an hirachical tree. I have to now display the data however in the way a directory structure is displayed. Following data used for example :
ID :Name :FK(Foreign Key)
1 :The Boss(Transport company) :NULL
2 :CEO :1 reports to(The Boss:1)
3 :Financial Manager :2 reports to(CEO)
4 :Labor Mnager :2 reports to(CEO)
5 :Transport Manager :2 reports to(CEO)
6 :The Boss(A internet company) :NULL
7 :CEO :6 reports to(The Boss:6)
8 :Financial Manager :7 reports to(CEO)
9 :Labor Mnager :7 reports to(CEO)
10 :Networking Manager :8 reports to(Financial Manager)
There can many toplevel Entrys with x amout of subentrys. Now what would be the best way to displaying them ? Secondly how can I change or modify the text value displayed in a DBGrid before it is displayed on the DBGrid. Thirdly how can I make DRGrid column give the user a Yes/No choice where the base type of the field is an integer but it stores either a 1 or a zero and how to display this as true and false on a 1 or 0 but not on other values.
Any help will be appreciated.