Searches for a set of values specified in varSval, in column iColumn starting at iRow. Upon successful completion, the row number with the matching value is returned in piRowFound.
HRESULT find ( LONG iRowStart, LONG iColumn, VARIANT varSval, OSPFIND findFlags, OSPCOMP compType, LONG *piRowFound);
Parameters
Value | Meaning |
---|---|
OSPFIND_DEFAULT = 0 | Specifies that the search operation should be in ascending order through rows in a case-insensitive manner. |
OSPFIND_UP = 1 | Specifies that the search operation should be in descending order through rows. |
OSPFIND_CASESENSITIVE = 2 | Specifies case-sensitivity for the search. |
OSPFIND_UPCASESENSITIVE = 3 | Specifies that the search operation should be in ascending order through rows in a case-sensitive manner. |
Value | Meaning |
---|---|
OSPCOMP_EQ = 1 OSPCOMP_DEFAULT = 1 |
Specifies that the search is for the first value equal to varSval. |
OSPCOMP_LT = 2 | Specifies that the search is for the first value less than varSval. |
OSPCOMP_LE = 3 | Specifies that the search is for the first value less than or equal to varSval. |
OSPCOMP_GE = 4 | Specifies that the search is for the first value greater than or equal to varSval. |
OSPCOMP_GT = 5 | Specifies that the search is for the first value greater than varSval. |
OSPCOMP_NE = 6 | Specifies that the search is for the first value not equal to varSval. |
Return Codes
Comments
Using the native type of the underlying column, OLEDBSimpleProvider::find performs compares. Providers should return DISP_E_TYPEMISMATCH when they are unable to convert the varSval to the underlying type of the column.
Comparing string values always compares values as they would be returned from a call to OLEDBSimpleProvider::getVariant with OSPFORMAT_FORMATTED. Providers should not coerce values of varSval obtained from a previous call to OLEDBSimpleProvider::getVariant with OSPFORMAT_HTML.