Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: form trigger mixup

Re: form trigger mixup

From: Karsten Farrell <kfarrell_at_medimpact.com>
Date: Mon, 21 Oct 2002 23:28:43 GMT
Message-ID: <L40t9.201$pT4.20926507@newssvr14.news.prodigy.com>


P B wrote:
> I'm trying to build a locator form made of two block, one to enter
> parameter for the query and one to display the result. In my parameter
> block, I have a checkbox and a text box. To make a new query, I've put
> a WHEN-CHECKED-BOX-CHANGE trigger which call a function that will
> perform the query. This work fine.
>

Should you be using an OK button instead of a checkbox to tell the form when to take the text box text and run with it? Using a checkbox to signal when you want to do a query is slightly different than MS Windows or X Windows behavior.

> But if I change the content of the text box nothing append and I dont
> seem to find a trigger that can do the call to the query function.
>

If a trigger fired on every change to a text box, it would fire every time you typed any character ... and how would it know when you were done typing? I think that's why nothing happens until you do something else, like click an OK button (so you can put a trigger on that).

> The function create a query sentence, then change the block property
> with the new sentence, then do a GO_BLOCK, then a EXECUTE_QUERY.
>
> Most of the the, the error that I got is that I cannot perform a
> GO_BLOCK
>
> Is there a kind of "standard" way to build such form?
>
> thanks
Received on Mon Oct 21 2002 - 18:28:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US