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.
>
> 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.
>
> 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
From your description I can't tell what you are doing or trying to do with certainty. Can you provide a clearer explanation? Have you looked at the VALIDATE triggers?
Daniel Morgan Received on Mon Oct 21 2002 - 18:03:59 CDT
![]() |
![]() |