Events.OnLoad

Description

The CopyOnLoad event is executed when an Add page is loaded in a Copy mode.

Syntax

CopyOnLoad($values,$where,$pageObject)

Arguments

$values

an array of values to be displayed on the page. You can modify the values of this array.

Note: To access a specific field value use $values["FieldName"].

Example: to clear the PassportNumber field value before copying, use $values["PassportNumber"]="";.

 

Note: Field names are case-sensitive. If the field name is PlayerId, you should use $values["PlayerId"]. Note that $values["playerid"] or $values["PlayerID"] will not work.

 

Note: If the field was assigned an alias in the SQL query, then the $values array will get the alias instead of the field name from the database.

E.g., if you have an SQL query SELECT salesrep_id AS Inv_Salesrep ..., you should use $values["Inv_Salesrep"].

 

$where

WHERE clause that points to the record to be copied. Example: ID=19.

$pageObject

an object representing the current page. For more information, see RunnerPage class.

Applies to pages

Add page (in Copy mode).

Recommended predefined actions and sample events:

•Send a simple email

•Send an email with old data

•Save old data in another table

•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

See also:

•Choose pages screen

•Export/Import pages

•About SQLQuery class

•About SQLQuery screen

•Additional WHERE tabs