Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: form trigger mixup
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
![]() |
![]() |