Stored procedure to delete a record
Default:
The SQL to perform the delete. For example, if you need to use the following stored procedure DeleteRow to delete a record with a primary key column with the name "key":
UPDATE XTABLE SET X_HIDE='YES' WHERE ID={key}
and the variable {key} will be substituted with the correct values.
Note: actually you can use any variable name for the key as phpLens searches for a variable delimited by { }.
If the first character is '=', then it is evaluated by PHP first like the powerLens.Syntax
$lens->spDelete = "UPDATE XTABLE SET X_HIDE='YES' WHERE ID={key}"; Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]
|