Set

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