|
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
|
