OraFAQ Forum: Forms » Hide a single Row field of Multi record Item

Home » Developer & Programmer » Forms » Hide a single Row field of Multi record Item (Oracle forms 10g, Win XP)

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

Hide a single Row field of Multi record Item [message #481422]

Wed, 03 November 2010 07:48

infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA

Member

Hi,

Consider below is a multi record block rows, i want to hide "23". Is it possible using Set_Item_Instance_Property or any other built-in is there in oracle forms to hide a single row field in a multi record block.

11 12 13
21 22 23
31 32 33
. . .

Regards,
Sruesh.V

Report message to a moderator

Re: Hide a single Row field of Multi record Item [message #481426 is a reply to message #481422]

Wed, 03 November 2010 08:12

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Set_item_instance_property is used to set properties on an item in a particular row - Read up on it in form builder help.
However I don't believe it'll help you here.

Report message to a moderator

Re: Hide a single Row field of Multi record Item [message #481473 is a reply to message #481422]

Wed, 03 November 2010 12:57

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

This is a VERY general question with not a lot of detail. I'll take a stab at a solution, but it probably will not be what you want.

In the multi-record block, have the real column not displayed. Have a non database text item (or display item) displayed in place of the column on the canvas. Have a trigger on when-new-item-instance or post-change or when-validate-item that sets the display field to null if the real column = 23.

Report message to a moderator

Re: Hide a single Row field of Multi record Item [message #481480 is a reply to message #481473]

Wed, 03 November 2010 14:24

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

Senior Member
Account Moderator

I'd add the POST-QUERY trigger as well. (I like the idea!)

Report message to a moderator

Previous Topic:	how to connect query??????
Next Topic:	How to stop system message.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 03:19:25 CDT 2024