can i highlight the record in a block [message #511020] |
Thu, 09 June 2011 02:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bc527a3a024fa498a3a8c878ec82e08d?s=64&d=mm&r=g) |
new_oracle2011
Messages: 174 Registered: March 2011 Location: Qatar
|
Senior Member |
|
|
hello everybody..
As from the title can i high light some records in a data block?
let me tell you the situation.
I am fetching almost 10 - 12 records in a datablock and it is working perfectly fine. but there are some records coming in the block which i want to make permanently red or dimmed just showing as they are black listed. is this possible?? or i have to try some other way??
|
|
|
|
|
|
|
Re: can i highlight the record in a block [message #511036 is a reply to message #511033] |
Thu, 09 June 2011 03:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Huh, I think I know what you are asking, actually: whether there's a simpler way to do that (such as "SET_RECORD_INSTANCE_PROPERTY" or similar). Unfortunately, there isn't, so you have to specify item by item:
if :sal < 2000 then
set_item_instance_property('empno', current_record, visual_attribute, 'low_sal');
set_item_instance_property('ename', current_record, visual_attribute, 'low_sal');
set_item_instance_property('job' , current_record, visual_attribute, 'low_sal');
set_item_instance_property('mgr' , current_record, visual_attribute, 'low_sal');
etc.
end if;
[Updated on: Thu, 09 June 2011 03:31] Report message to a moderator
|
|
|
|
|
|
|
Re: can i highlight the record in a block [message #511640 is a reply to message #511633] |
Tue, 14 June 2011 06:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Of course there's a way. You just need to do the inverse of what you are doing.
Set update_allowed to true at block and item level.
Set it to false at item instance level for all items you want to disallow update on.
|
|
|