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: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 21 Oct 2002 23:03:59 GMT
Message-ID: <3DB487CF.541EBCF5@exesolutions.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.
>
> 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

Original text of this message

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