Find Method
This method will find the Bookmark of the row using the searchMode and the searchStr.
column.Find(searchStr, searchMode, includeStart, [startBmk])
Arguments
SearchStr is a String or a number to search for.
SearchMode is the comparing mode for search, it may take the following values:
-1. |
dblSeekLT |
Finds the first match such that the column value is less than searchStr. |
-2. |
dblSeekLE |
Finds the first match such that the column value is less than or equal to searchStr. |
-3. |
dblSeekEQ |
Finds the first match such that the column value is equal to searchStr. |
-4. |
dblSeekGE |
Finds the first match such that the column value is greater than or equal to searchStr. |
-5. |
dblSeekGT |
Finds the first match such that the column value is greater than searchStr. |
-6. |
dblSeekPartialEQ |
Finds the first match such that searchStr is the leading part of the column string, for example, “ab” is the leading part of “abstract”. |
-7. |
dblSeekIncludeEQ |
Finds the first match such that the searchStr is included somewhere within the column string, for example, “put” is within the column string “computer”. (Note: This SearchMode is only available in OLEDB.) |
IncludeStart takes values TRUE or FALSE. If the value is TRUE, the search will start from the startBmk, otherwise the search will start from the row right after the startBmk
StartBmk is the bookmark of the row where search starts. This argument is optional, if it does not appear, the startBmk will be the first row on the control.
Return Value
Return value is the Bookmark of row where the first match is found if the search is successful, otherwise return NULL.
Method applies to Column object.
This method can be used for bounded, unbounded and storage mode.
See Also