Before SQL query

Description

The BeforeQuery<PageName> event is executed before a SELECT SQL query is processed. Use this event if you like to modify default SQL query, add a WHERE clause, etc.

Syntax

BeforeQuery<PageName>($strSQL,$strWhereClause,$strOrderBy,$pageObject)

Arguments

$strSQL

an SQL query to be executed.

$strWhereClause

a WHERE clause to apply to the SQL query.

$strOrderBy

ORDER BY query to apply to the SQL query.

$pageObject

an object representing the current page. For more information, see RunnerPage class.

Applies to pages

List, Print, Export, Chart.

See also:

•Choose page screen

•SQL query screen

•About SQLQuery class