Method Locate(KeyFields: string, KeyValues: Variant, CaseInsensitive: boolean, PartialKey: boolean): boolean

Description

This function can be used for searching for a particular record in the result set based on a number of field conditions.

• KeyFields

  Field names of key fields used for searching. If multiple fields are used, these are separated by a ; character.

• KeyValues

  Values for key fields used for searching. If multiple fields are used, an array of variants should be used.

• CaseInsensitive

  Should the search be case insensitive (= TRUE) or not (= FALSE)?

• PartialKey

  Will fields with only a part of the key value apply (= TRUE) or not (= FALSE)?

• Result

  Indicates whether a record that meets the conditions exists (= TRUE) or not (= FALSE). If this is the case this record will immediately become the active record.