|
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 has been
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 replaced 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
|
