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