-
i want to the back ground color of few records to change based on the value
for example i have a form in tabular form and 10 records are displayed
i want to change the background color of those reocrds where the deptno is 10 and i want this to happen when i execute query..
i tried all the ways but i cud'nt .....
i am able to do it..record by record..int eh when_new_record_instance tirgger..but not the other way around.
bob
-
U should use SET_ITEM_INSTANCE_PROPERTY
DECLARE
cur_itm VARCHAR2(80);
cur_block VARCHAR2(80) := :System.Cursor_Block;
BEGIN cur_itm := Get_Block_Property( cur_block, FIRST_ITEM );
WHILE ( cur_itm IS NOT NULL ) LOOP
cur_itm := cur_block||'.'||cur_itm;
Set_Item_Instance_Property( cur_itm, CURRENT_RECORD, VISUAL_ATTRIBUTE,'My_Favorite_Named_Attribute');
cur_itm := Get_Item_Property( cur_itm, NEXTITEM );
END LOOP;
END;
1) create special visual attribute
2) use this attribute in Set_Item_Instance_Property procedure.
-
thanks it works
hi ,
it works thanks a lot....
gr8
cheers
bob
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|