Contents

 
Home
ASPRunner Professional 8.1 manual
Prev Page Next Page
 
 

Event: BeforeQuery<PageName>

 

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,pageObject)

Arguments

strSQL - SQL query to be executed.

strWhereClause - WHERE clause applied to the SQL query. Example: "active=1".

strOrderBy - ORDER BY query applied to the SQL query. Example: "ORDER BY LastName,FirstName".

pageObject - an object representing the current page. For more information, see Page class.

Applies to pages

List, Print, Export, Chart

Recommended predefined actions and sample events

Send a simple email

Insert a record into another table

Check to see if a specific record exists

Display a message on the Web page

Redirect to another page

Dynamic SQL Query

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)