Home » Developer & Programmer » Forms » How to Put value for query in Display Item Forms 6i
How to Put value for query in Display Item Forms 6i [message #203782] Thu, 16 November 2006 05:17 Go to next message
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
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 Go to previous message
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)

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


Current Time: Fri Dec 09 13:40:56 CST 2016

Total time taken to generate the page: 0.14255 seconds