Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Methods >

<ADODB_Recordset>.Find

Previous pageReturn to chapter overviewNext page

 

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