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

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.

Locked on Jun 12 2009

Added on May 15 2009

#forms, #moved-from-devops

3 comments

519 views

Oracle Forms

Change color or Error records to Red

Comments

Post Details