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>


	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

Original text of this message