Re: Forms 3.0 pre-query question ???
From: Greg Moore <mooreg_at_interaccess.com>
Date: 6 Jan 1994 01:58:04 GMT
Message-ID: <2gfr7d$bvi_at_mailhost.interaccess.com>
Date: 6 Jan 1994 01:58:04 GMT
Message-ID: <2gfr7d$bvi_at_mailhost.interaccess.com>
The PRE-QUERY trigger fires every time a query is executed. If you want to execute a query conditionally, you can write a KEY-EXEQRY trigger: if (:field_1 = 'L' or :field_1 = 'R') and :field_2 > 1200 then execute_query; end if; Now the query will execute only if the conditions are true. Note, when the query does execute, the PRE-QUERY will fire. You might use it to place a value in a field to limit the results of a query. Or you could use it to perform other functions you want to have happen just before the query is executed.Received on Thu Jan 06 1994 - 02:58:04 CET