Oracle Objects for OLE
Release 8.1.7

Part Number A85257-01

Library

Product

Contents

FindFirst, FindLast, FindNext, FindPrevious Methods

See Also
Example
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.


 
Oracle
Copyright copy; 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents