ASPRunnerPro 9.6 manual
Prev Page Next Page

Event: BeforeQuery<PageName>



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.




strSQL - SQL query to be executed.

strWhereClause - WHERE clause applied to the SQL query. Example: "active=1". This argument is "read-only". If you need to change WHERE clause, you can do it using AfterTableInitialized event. See example.

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)