|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Methods > <ADODB_Recordset>.Find |
Description
Searches for a record in a ADODB_Recordset that satisfies a specified criteria.
If the search is successful, the record pointer will point to the first found record.
Syntax
<ADODB_Recordset>.Find(sCriteria [, skiprows [, direction [, start]]])
Returns
None.
Parameters
Name |
Type |
Optional |
Meaning |
sCriteria |
String |
No |
The column name, comparison operator, and value to use in the search. Examples:
"Country='Norway'" "Date>#7/22/97#" "Country LIKE N*"
Note: This method does not support multi-column searches (AND or OR) |
skiprows |
Number |
Yes |
Specifies how many records beyond the current record to skip before beginning the search. Default is 0 |
direction |
Number |
Yes |
A SearchDirectionEnum value that specifies the search direction |
start |
Number |
Yes |
The starting position for the search |
Remarks
Restrictions
A current row position (like MoveFirst) must be set before calling this method, otherwise an error will occur.
See also
Examples