|
Description
Function BeforeEdit is executed before a data
record is updated in the database.
Syntax
|
BeforeEdit($values,$where,$oldvalues,$keys,$message,$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.
$message - place the message to be
displayed into this variable.
$inline - equals to true when the
Inline Edit in process, false otherwise.
Return value
True: changes will be saved.
False: changes would not be saved.
Applies to pages
Edit, Inline Edit
Recommended predefined actions
and sample events
Send
a simple email
Send an email with new
data
Send an email with old
data
Save new data in another
table
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
Send an email with
updated fields only
Check size and
extension of upload files
Rename uploaded files
Check if start
date is ealier than end date
|
