OraFAQ Forum: Forms » how to highlight a column in a multirecord database block

Home » Developer & Programmer » Forms » how to highlight a column in a multirecord database block (Forms 6i)

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

how to highlight a column in a multirecord database block [message #325944]

Mon, 09 June 2008 11:38

rahul15june
Messages: 35
Registered: May 2008

Member

Hi,

I have a multirecord database block with field like Monday, Tuesday...Sunday.

Now when data is loaded I use, "Execute Query", The current days column (like say today is Monday), then that column (not row/record) should get highlighted.

I tried using

Set_item_instance property('item',current_record,visual_attribute,va_99)

I tried using

set_item_instance ('item',background_color,'red')

but that also did not work.

I want whole column highlighted not record/row.

I tried in Post_query, Post_select, pre_select, pre_query.

Thanks,
Rahul

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #325948 is a reply to message #325944]

Mon, 09 June 2008 11:47

Frank
Messages: 7901
Registered: March 2000

Senior Member

Why did you use set_item_instance_property instead of set_item_property?

set_item_instance_property is a specific form of set_item_property, meant to only highlight a single row!

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #325967 is a reply to message #325948]

Mon, 09 June 2008 14:26

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Because SET_ITEM_INSTANCE_PROPERTY is the way to do that Smile

There were several answers to a similar question; this is one of these.

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #325972 is a reply to message #325967]

Mon, 09 June 2008 14:43

Frank
Messages: 7901
Registered: March 2000

Senior Member

The question was (if I read it correctly) to highlight a column, not a row.

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #325973 is a reply to message #325972]

Mon, 09 June 2008 14:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Right, but SET_ITEM_INSTANCE_PROPERTY (SIIP) is the way to do that; highlighting the whole record only complicates things as one has to use SIIP for every item separately (in other words, too bad that there's no such a property for SET_RECORD_PROPERTY built-in).

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #325987 is a reply to message #325944]

Mon, 09 June 2008 15:31

Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium

Member

I use POST-QUERY without a problem, SIIP is for individual cells
so set_item_property is best and fastest

POST-QUERY :

if :system.trigger_record = '1' then
  Set_item_property('last_name', visual_attribute, 'VA_RED');
end if;

you only need to change the color once, that's what the if then is there for
this has the added value of turning the field label red as well Smile

other option (slower)
POST-QUERY :

  Set_item_instance_property('last_name',current_record,visual_attribute, 'VA_RED');

Report message to a moderator

Re: how to highlight a column in a multirecord database block [message #326120 is a reply to message #325987]

Tue, 10 June 2008 04:42

rahul15june
Messages: 35
Registered: May 2008

Member

Thanks Martin,

Your solution worked like a charm.

Thanks everyone else also for your inputs.

thanks,
Rahul

Report message to a moderator

Previous Topic:	Blank Report
Next Topic:	Order by

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 06:51:39 CST 2025