Modify

Description

Modifies an existing sub-expression identified by expression_id or adds a new sub expression. Pass an empty string as the first parameter to remove an existing sub-expression.

Syntax

Function Modify(sql, expression_id, check_syntax)

Parameters

sql (input) - SQL database parameters, the WHERE clause

expression_id (input) - the ID of the expression to modify

check_syntax (input) - turn check_syntax on or off

Return value

the modified values

Example

Sample code

Scope.Modify "ID=26", 1, true

See also

Platform Objects and Methods

DB.sort

DB.AppendFinish

DB.SetFieldValue

DB.TransactionFinish