OraFAQ Forum: Forms » Setting Visual attribute to a specific record in tabular block if the condition is satisfied

Home » Developer & Programmer » Forms » Setting Visual attribute to a specific record in tabular block if the condition is satisfied (Oracle Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Setting Visual attribute to a specific record in tabular block if the condition is satisfied [message #356834]

Sun, 02 November 2008 14:11

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	HDD SerialNumber
Next Topic:	form6i lov

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 15:01:44 CST 2025