|
Description
Function AfterEdit is executed after a data
record was updated in the database.
Syntax
|
AfterEdit($values,$where,$oldvalues,$keys,$inline)
|
Arguments
$values - array of values to be
written to the database. To access specific field value use
$values["FieldName"].
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.
If the field was assigned an
alias in the SQL query, then the $values array will get the alias
instead of field name from the database. E.g. if you have SQL query
select salesrep_id AS
Inv_Salesrep ..., you should use $values["Inv_Salesrep"].
$where -WHERE clause that points to
the edited record. Example: ID=19.
$oldvalues - array with existing field
values. To access specific column value use $oldvalues["FieldName"].
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.
If the field was assigned an
alias in the SQL query, then the $oldvalues array will get the alias
instead of field name from the database. E.g. if you have SQL query
select salesrep_id AS
Inv_Salesrep ..., you should use $oldvalues["Inv_Salesrep"].
$keys - array of key column values
that point to the edited record. To access specific key column use
$keys["KeyFieldName"].
Field names are
case-sensitive. If the field name is PlayerId, you should use $keys["PlayerId"]. Note that
$keys["playerid"] or
$keys["PlayerID"] will not
work.
$inline - equals to true when the
Inline Edit in process, false otherwise.
Applies to pages
Edit, Inline Edit
Recommended predefined actions
and sample events
Send
a simple email
Send an email with new
data
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
|
