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: connectivity problem forms 6i with oracle 9i on winxp p4
Next Topic: Update a date field using calendar
Goto Forum:
  


Current Time: Tue Aug 22 17:45:31 CDT 2017

Total time taken to generate the page: 0.05237 seconds