How Icons and an Overlay Condition Were Defined

Previous Next

To define icons and overlay conditions, these steps were taken:

1.For the Tree View object, on the Visual tab page, set Show Icons to Yes.
2.For Tree View Node 1, on the Visual tab page, set Image to:

C:\Program Files\USD70\BITMAPS\primkey.ico

3.For Tree View Node 2, on the Visual tab page, set Image to:

C:\Program Files\USD70\BITMAPS\column.ico

4.For Tree View Node 3, on the Visual tab page, set Image to:

C:\Program Files\USD70\BITMAPS\transpar.ico

Setting the Image property is obligatory when you define an overlay image. The transpar.ico image is not visible but there can be another image superimposed on it.
5.For Tree View Node 3, on the Behavior tab page, set Overlay Condition to:

SELECT    'overbooked'

FROM    dual

WHERE    :max_part <

   (SELECT    COUNT(*)

    FROM    participant pt,

       reservation r

    WHERE    pt.res_id=r.res_id

    AND    r.schedtour_id=:SCHEDTOUR_ID)

 

This condition checks if the current Scheduled Tour is overbooked.
6.Set Overlay Image to:

C:\Program Files\USD70\BITMAPS\critic.ico