AddStringRestriction

AddStringRestriction adds a string restriction expression to the open RMS file

Syntax

Sub AddStringRestriction(rmsHandle As Integer, fldname As String, rmsop As Integer, strval As String )

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

strval

String value

Return Values

No return value

Remarks

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

See Also

AddStringRestrictionAddStringRestriction, AddCharRestrictionAddCharRestriction, AddIntegerRestrictionAddIntegerRestriction,

AddLongRestrictionAddLongRestriction, AddRealRestrictionAddRealRestriction, AddDateRestrictionAddDateRestriction,

AddTimeRestrictionAddTimeRestriction, AddBooleanRestrictionAddBooleanRestriction, GetFieldTypeGetFieldType,

GetFieldTypebyNameGetFieldTypebyName, AddStringRestriction