|
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
|
