Home » Developer & Programmer » Forms » Setting Visual attribute to a specific record in tabular block if the condition is satisfied (Oracle Forms 6i)
Setting Visual attribute to a specific record in tabular block if the condition is satisfied [message #356834] Sun, 02 November 2008 14:11 Go to next message
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
Member
Hi people,

I am new to Oracle Forms so I am not sure is this possible at all with Oracle Forms 6i.

Let me explain. I created a tabular data block, based on a view.

I want to set a color (for instance, red) for a specific record in that block if condition is satisfied.

For instance, a record consists of these items (id, item1, item2), and there are ten records displayed. So I would like to set a visual attribute only to those records where item2='some value';

[Updated on: Sun, 02 November 2008 14:13]

Report message to a moderator

Re: Setting Visual attribute to a specific record in tabular block if the condition is satisfied [message #356838 is a reply to message #356834] Sun, 02 November 2008 14:51 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, there is a way - SET_ITEM_INSTANCE_PROPERTY built-in might help.

As suggested in the OraFAQ Forum Guide's "How to get a quick answer to your question" section, Search can help in many cases - this is one of them. Here is one example; you'll probably find a few more if you decide to dig a little bit deeper.
Re: Setting Visual attribute to a specific record in tabular block if the condition is satisfied [message #356843 is a reply to message #356834] Sun, 02 November 2008 15:13 Go to previous messageGo to next message
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
Member
Thank you very much.

I used SET_ITEM_INSTANCE_PROPERTY in POST-QUERY and it worked for an item. I realize now, there is no way to set visual attribute for a record, smth like SET_RECORD_... in the same way it works for instance.
Re: Setting Visual attribute to a specific record in tabular block if the condition is satisfied [message #356845 is a reply to message #356843] Sun, 02 November 2008 15:51 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; set property for every item itself as SET_RECORD_PROPERTY can't do that. Or, alternatively, write your own procedure that will modify all items in a record.
Previous Topic: HDD SerialNumber
Next Topic: form6i lov
Goto Forum:
  


Current Time: Sun Dec 04 00:40:42 CST 2016

Total time taken to generate the page: 0.18192 seconds