FirstRestrictionRecord gets the first open RMS file record marching all the registered restriction expression and stores it in internal buffer
Function FirstRestrictionRecord (rmsHandle As Integer, rhiloflag As Integer) As Integer
rmsHandle
RMS file handle
rhiloflag
Next record search direction
On success, FirstRestrictionRecord returns 1. If failed, it returns 0.
FirstRestrictionRecord selects a index to use to search the first matching record based on the registered restrictions. It returns a next record search direction (forward/backward) through rhiloflag passed in as the second parameter. If the restriction operator is LE/LT the direction is backward or if the restriction operator is GE/GT the direction is forward. The returned rhiloflag must be passed to NextRestrictionRecord to get the next matching records.
To get fields data:
If function RegisterField is not called, first call GetFieldCount to get the number of fields in
the RMS file then for each field call GetFieldType and GetStringField , GetCharField ,
GetIntegerField , GetLongField , GetRealField , GetMoneyField , GetDateField ,
GetTimeField , GetBooleanField depends on the field types.
If function RegisterField is called, call FirstRegistedField and NextRegistedField to get
the field names corresponding to the field data in the query buffer and for each field name call
GetFieldTypebyName and GetStringFieldbyName , GetCharFieldbyName ,
GetIntegerFieldbyName , GetLongFieldbyName , GetRealFieldbyName ,
GetMoneyFieldbyName , GetDateFieldbyName , GetTimeFieldbyName and
GetBooleanFieldbyName depends on the field types.
AddStringRestriction , AddCharRestriction , AddIntegerRestriction ,
AddLongRestriction , AddRealRestriction , AddDateRestriction ,
AddTimeRestriction , AddBooleanRestriction , GetFieldType ,
GetFieldTypebyName , AddStringRestriction