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)

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