Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Change color or Error records to Red

abcdxyzMay 15 2009 — edited May 15 2009
Hi all
I Have a detail block which has a column status
When the status of the record is 'ERROR'
i want the record to be shown in red
How do i do it
Please help me
Thanks

Comments

François Degrelle
Hello,

Use the Set_Item_Instance_Property() built-in on each item of the record, with a Visual Attribute that have the foreground or the background color set to red.

Francois
Grant Ronald-Oracle
You can usually do this on a post query trigger but be aware that with web deployed Forms you will potentially be generating quite a bit of client network traffic so be aware just incase this starts to give you performance problems.

Regards
Grant
598585
Make a Visual attribute 'VIS' with foreground and background colour as RED and write the following code in post query trigger of the block.

if :Block.status='yourcondition' then
set_item_instance_property('status',CURRENT_RECORD,VISUAL_ATTRIBUTE,'VIS');
end;

Please mark the answer in case it helped
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 12 2009
Added on May 15 2009
#forms, #moved-from-devops
3 comments
522 views