Back

Editing, Updating and Creating Records
spDelete
Stored procedure to delete a record 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": `call DeleteRow ({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 = 'call DeleteRow ({key})';` Basic:No Advanced/Enterprise:Yes DynamicEdit:No [Version 1.0]