function Find(ColumnsToSearch: array of String; SearchValues:
      array of Variant; NearestMatch: Boolean=False; CaseInsensitive:
      Boolean=False; LocaleInsensitive: Boolean=False): Boolean

Usage

Available In: Client and Server Applications

Use this method to complete a find operation and perform the actual search of the dataset for a row that matches the column values provided in the ColumnsToSearch and SearchValues parameters. This method will return True if a row is found with the specified column values, or False if not. Specify True for the NearestMatch parameter to cause the search to return the closest match to the desired row, if the desired row cannot be found. Specify True for the CaseInsensitive parameter to cause the search to be executed in a case-insensitive manner for any string columns. Specify True for the LocaleInsensitive parameter to cause the search to be executed in a locale-insensitive manner for any string columns.