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