OraFAQ Forum: Forms » How to Put value for query in Display Item Forms 6i

Home » Developer & Programmer » Forms » How to Put value for query in Display Item Forms 6i

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

How to Put value for query in Display Item Forms 6i [message #203782]

Thu, 16 November 2006 05:17

sauami
Messages: 54
Registered: October 2005
Location: india

Member

Dear Sir,

I have a display item i want to put the value in the item when i press f6 or other key for query purpose pls. tell me how to forcefully i can use display item for query purpose.

Thanks,
Saurabh

Report message to a moderator

Re: How to Put value for query in Display Item Forms 6i [message #203814 is a reply to message #203782]

Thu, 16 November 2006 07:34

pchircop
Messages: 4
Registered: November 2006

Junior Member

Hi, you can not use a display item (let's say my_item),
use a text item instead

1) if the item is not table based
(property query_only=true, database item=false)

In the pre-query trigger of the block to query (let say my_block), you can dynamically construct a where clause using the value of <my_item> (in to a varchar2 variable, let's say my_qry) and then issue

set_block_property('myblock',default_where,my_qry);

2)if the item is table based
(property query_only=true, database item=true)

Report message to a moderator

Previous Topic:	Update multiple records in a form
Next Topic:	Sort

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:25:01 CDT 2024