A script-enabled browser is required for this page to function properly.

Pre-Select Trigger

Description

Fires during Execute Query and Count Query processing, after Oracle Forms constructs the SELECT statement to be issued, but before the statement is actually issued. Note that the SELECT statement can be examined in a Pre-Select trigger by reading the value of the system variable SYSTEM.LAST_QUERY .

Definition Level form or block

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode no

Usage Notes

Use a Pre-Select trigger to prepare a query prior to execution against a non-ORACLE data source.

On Failure

No effect. The current query fetched no records from the table. The table is empty, or it contains no records that meet the query's search criteria.

Fires In

EXECUTE_QUERY

Open the Query

Prepare the Query


SYSTEM.LAST_QUERY examples