Please enable JavaScript to view this site.

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

Events.After record updated

Scroll Prev Next More

Description

The AfterEdit event is executed after the data record was updated in the database. It works in all edit modes: Inline Edit, Regular Edit and an Edit page in a popup.

Syntax

AfterEdit($values,$where,$oldvalues,$keys,$inline,$pageObject)

Arguments

Note: Field names are case-sensitive. If the field name is PlayerId, you should use $oldvalues["PlayerId"]. Note that $oldvalues["playerid"] or $oldvalues["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"].

 

$values

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

$where

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

$oldvalues

an array with existing field values. To access a specific column value, use $oldvalues["FieldName"].

$keys

an array of key column values that point to the edited record. To access a specific key column, use $keys["KeyFieldName"].

$inline

equals to true for the Inline Edit, false otherwise.

 

$pageObject

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

Note: If you need to display a message on the page or pass a variable value to JavaScript, you need to add the following to the end of your event code:

$pageObject->stopPRG = true;

Example

Passing true to pageObject.stopPRG = true variable named "saved":

 

$pageObject->setProxyValue('saved', true);  
$pageObject->stopPRG = true;

Applies to pages

Edit, Inline Edit.

Recommended sample events:

Add new button to Add/Edit pages

Change message after record was added or saved

Send mass email to al users

See also:

AJAX helper object: setMessage()

About Javascript API

setProxyValue

Choose pages screen

About SQLQuery class

About SQLQuery screen

Additional WHERE tabs

Before record updated

Custom record update

 

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