Re: Query question.

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Tue, 25 May 1999 14:06:17 +0800
Message-ID: <374A3DD9.FA330E37@ccis.adisys.com.au>

Kim wrote:

> Hi
> I want to be able to do a query without having to use the query button.
> for example do a query for K% within a pl/sql block, i have tried several
> approaches like:
>
> execute_query('K%')
>
> And I have tried copying the search text to the right block and afterwards
> running execute_query
>
> But without any luck
> I hope somebody out there can help me with this problem.
>
> Thanks
> Kim

If I understand the problem correctly what you need to do is use a pre-query trigger to put the 'K%' into the item of the block. Then, when you execute_query on the block the 'K%' will be added and used by the query for filtering.

HTH
Geoff Received on Tue May 25 1999 - 01:06:17 CDT