|
To define the
Scheduled Tours tree view, these steps were taken:
| 1.
|
In the Property Inspector, select the Tree View 1 object (the
Tree View, not the Tree View Node or the Tab Page). |
| 2.
|
The tree view already contains one Tree View Node. You need two
more. Open the Controls tab page of the cataloge, move the mouse
over the icons until the status bar says "Tree View Node", and then
drag-and-drop two Tree View Nodes from the Controls tab page onto
the design view. |
| 3.
|
Using the Object tree, verify that the tree view now has 3 tree
view nodes. |
| 4.
|
For Tree View Node 1, set Child Nodes to Tree View Node 2. |
For Tree View Node 2, set
Child Nodes to Tree View Node 3.
Save your work so far.
| 5.
|
Define the application data that the catalog is going to
retrieve and display. |
For Tree View Node 1, set SQL
Query to:
SELECT DISTINCT destination
FROM tour
| 6.
|
For Tree View Node 2, set SQL Query to: |
SELECT tour_type,destination
FROM tour
WHERE destination=:DESTINATION
NOTE:
Only the TOUR_TYPE column, the
first selected column, is shown in the tree. The DESTINATION column
will be used in the SQL Query of Tree View Node 3.
| 7.
|
For Tree View Node 3, set SQL Query to: |
SELECT TO_CHAR(start_date,'YYYY/MM DD
Day'),schedtour_id,max_part
FROM schedtour
WHERE destination =
:DESTINATION
AND tour_type =
:TOUR_TYPE
|
