Show/Hide Toolbars

ASPRunnerPro 9.8 Manual

Navigation: Advanced topics > Events > Table events > List page

ASPRunnerPro32x32     ASPRunnerPro manual


Event: BeforeQuery<PageName>

Scroll Prev Next More

 

Description

Function BeforeQuery<PageName> is executed before 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 - SQL query to be executed.

strWhereClause - WHERE clause applied to the SQL query.

strOrderBy - ORDER BY query applied to the SQL query.

Applies to pages

List, Print, Export, Chart