* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
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
