AddBooleanRestriction

AddBooleanRestriction adds a boolean restriction expression to the open RMS file

Syntax

Sub AddBooleanRestriction(rmsHandle As Integer, fldname As String, rmsop As Integer, boolval As Integer)

Parameters

rmsHandle

RMS file handle

fldname

Field name

rmsop

Restriction operator.  Supported values:

EQ            equal

                    NE          not equal

                    LE          less than and equal

                    LT          less than

                    GE          greater than and equal

                    GT          greater than

boolval

Boolean value as integer. 1=TRUE, 0=FALSE

Return Values

No return value

Remarks

Call AddBooleanRestriction to add a boolean field restriction expression to the open RMS file before calling FirstRestrictionRecordFirstRestrictionRecord to search records.  Always make sure the field type is CBBOOLEANTYPE for field with name fldname.

See Also

AddStringRestrictionAddStringRestriction, AddCharRestrictionAddCharRestriction, AddIntegerRestrictionAddIntegerRestriction,

AddLongRestrictionAddLongRestriction, AddRealRestrictionAddRealRestriction, AddDateRestrictionAddDateRestriction,

AddTimeRestrictionAddTimeRestriction, AddBooleanRestrictionAddBooleanRestriction, GetFieldTypeGetFieldType,

GetFieldTypebyNameGetFieldTypebyName, AddStringRestriction