Description

Sets an SQL expression to be used to filter records. The old object content is overwritten by a call to this method.

Syntax

Function Set(sql, expression_id, check_syntax)

Parameters

sql (input) - the SQL server parameters, the WHERE clause
expression_id (input) - the scope object can contain multiple sub-expressions joined by the AND operator. Set this parameter to a unique value to be able to identify this sub-expression later.
check_syntax (input) - turn on whether you want to check SQL syntax or not

Return value

none

Example

Sample code

Scope.Set "ID=25", 1, true

See also

Platform Objects and Methods

DB.sort

DB.AppendFinish
DB.SetFieldValue
DB.TransactionFinish