FindFirst Method
Applies To
OraDynaset
Usage
oradynaset.FindFirst FindClause
Where FindClause is any valid SQL where clause without the 'WHERE'.
Description
Finds the first row in the dynaset that matches FindClause. FindClause can be any valid where clause without the 'WHERE'. If the current FindClause matches the last clause from the previous Find, the current FindClause is not re-parsed.
This method moves the current row directly to a matched row without calling
any advisories except when the matched row is reached. If a matching row cannot
be found, the NoMatch property is set to TRUE and you are left at the row from
which you called FindFirst.
Remarks
You can use the following types of expressions in the FindClause:
· simple queries, such as "deptno = 20"
· queries involving complex expressions, such as "sal + 100 > 1000".
· SQL function calls, such as "UPPER(ename) = ‘SCOTT’ " or "NVL(comm, 0) = 0" .
· subqueries, such as "deptno in (select deptno from dept)".
Note: To avoid raising an error, check for EOF or BOF before calling a Find method.
FindLast Method
Applies To
OraDynaset
Usage
oradynaset.FindLast FindClause
Where FindClause is any valid SQL where clause without the 'WHERE'.
Description
Finds the last record in the dynaset that matches FindClause. FindClause can be any valid where clause without the 'WHERE'. If the current FindClause matches the last clause from the previous Find, the current FindClause is not re-parsed.
This method moves the current row directly to a matched row without calling
any advisories except when the matched row is reached. If a matching row cannot
be found, the NoMatch property is set to TRUE and you are left at the row from
which you called FindLast.
Note: To avoid raising an error, check for EOF or BOF before calling a Find method.
FindNext Method
Applies To
OraDynaset
Usage
oradynaset.FindNext FindClause
Where FindClause is any valid SQL where clause without the 'WHERE'
Description
Finds the next row in the dynaset that matches FindClause. FindClause can be any valid where clause without the 'WHERE'. If the current FindClause matches the last clause from the previous Find, the current FindClause is not re-parsed.
This method moves the current row directly to a matched row without calling
any advisories except when the matched row is reached. If a matching row cannot
be found, the NoMatch property is set to TRUE and you are left at the row from
which you called FindNext.
Note: To avoid raising an error, check for EOF or BOF before calling a Find method.
FindPrevious Method
Applies To
OraDynaset
Usage
oradynaset.FindPrevious FindClause
Where FindClause is any valid SQL where clause without the 'WHERE'
Description
Finds previous record in dynaset starting from current row that matches FindClause. FindClause can be any valid where clause without the 'WHERE'. If the current FindClause matches the last clause from the previous Find, the current FindClause is not re-parsed.
This method moves the current row directly to a matched row without calling
any advisories except when the matched row is reached. If a matching row cannot
be found, the NoMatch property is set to TRUE and you are left at the row from
which you called FindPrevious.
Note: To avoid raising an error, check for EOF or BOF before calling a Find method.