SearchFirstRecord finds the first RMS record of the open RMS file by using primary, secondary index or searching sequentially. It detects which index to use.
Function SearchFirstRecord(rmsHandle as Integer, bestindex As Integer) As Integer
bestindex
The flag controlling whether to use the best secondary index to search record. The flag
can be set to 1 or 0. If it is set to 1, the function tries to select the best secondary index
to find the record.
On success, SearchFirstRecord returns 1. If there is no matching record, it returns 0.
Before calling function SearchFirstRecord, you must set the query fields data by calling
functions RegisterStringFieldData , RegisterCharFieldData , RegisterIntegerFieldDataRegisterIntegerFieldData,
RegisterLongFieldData , RegisterRealFieldData, RegisterMoneyFieldData,
RegisterDateFieldData , RegisterTimeFieldData or RegisterBoolFieldData depends
on field types.
If you want to let function SearchFirstRecord store the specified fields data in the
internal query buffer, you can call RegisterField to add field names to the internal data query
field name list before calling function SearchFirstRecord. By default,
SearchFirstRecord store all fields’ data in the query buffer.
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.
SearchFirstRecord, SearchNextRecord, SearchPrevRecord,
SetSearchIndex, SearchLastRecord.