locateOptions
Determines how values are matched for locating.
Property of
Rowset
Description
The locateOptions property is an enumerated property that controls how the value properties in the field objects entered during Locate mode are matched against the values in the table. These are the options:
|
Value |
Effect |
|
0 |
Match length and case |
|
1 |
Match partial length |
|
2 |
Ignore case |
|
3 |
Match partial length and ignore case |
When matching partial length, the entire search value must match all or part of the value in the table, starting at the beginning of the field. For example, searching for "Century City", will match "Century City East", but "East" alone would not.
locateOptions also determines how fields are matched when using an SQL expression with the applyLocate( ) method.
The default setting for locateOptions is "Match length and case".