Home » Developer & Programmer » Forms » Highlight Multiple Rows In Oracle Form (Window7)
Highlight Multiple Rows In Oracle Form [message #624985] Mon, 29 September 2014 23:58 Go to next message
Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi
Member
Hi All,
how to highlight multiple rows in oracle Form iam using Oracle From 11g my scenario is that.
If :emp.comm is null then
<Highlight rows>
i also used
set_item_property('emp.comm',Visual_attribute,backgroud....etc);

but not get desire result any one help me about it.
sorry for weak english.

Regard
Nasir Azeem.
Re: Highlight Multiple Rows In Oracle Form [message #624988 is a reply to message #624985] Tue, 30 September 2014 00:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is SET_ITEM_INSTANCE_PROPERTY you should use, such as
if :emp.comm is null then
   set_item_instance_property('emp.comm', current_record, visual_attribute, 'comm_null');
end if;	
Re: Highlight Multiple Rows In Oracle Form [message #624989 is a reply to message #624988] Tue, 30 September 2014 00:33 Go to previous messageGo to next message
Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi
Member
i want to change background color. iam using your coding but it is not work properly.
getting error 41011 Undefined visual attribute.
i used this code on form trigger (Post_query).


if :emp.comm is null then
set_item_instance_property('emp.comm', current_record, visual_attribute, 'comm_null');
end if;

Re: Highlight Multiple Rows In Oracle Form [message #624992 is a reply to message #624989] Tue, 30 September 2014 02:10 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Think!

Of course it is not working properly. You don't have COMM_NULL visual attribute. Which ones you do have, I don't know - you never specified that in your messages.
Previous Topic: combobox - jump to item of a big list
Next Topic: Navigate to Particular Record
Goto Forum:
  


Current Time: Thu Mar 28 15:53:04 CDT 2024