Please enable JavaScript to view this site.

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

Before record exported

Scroll Prev Next More

Description

The BeforeOut event is executed before a record is exported. Use this event to modify the record before it is exported.

Syntax

BeforeOut($data,$values,$pageObject)

Arguments

$data

"In" Data. An array of values selected from the database table. To access a specific field value, use $data["FieldName"].

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

 

$values

"Out" Data. An array of values to be written to the database. To access a specific field value, use $values["FieldName"].

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"].

 

$pageObject

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

Return value

True - the record is exported.

 

False - the record is not exported.

Applies to pages

Export.

Recommended predefined actions and sample events:

Insert a record into another table

Check to see if a specific record exists

Display a message on the Web page

See also:

SQL query screen

About SQLQuery class

About Database API

Export/Import pages

 

Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software