Oracle Objects for OLE
Release 8.1.7

Part Number A85257-01

Library

Product

Contents

Moving to the Next Row

See Also
Quick Tour
Employee Form

We can position ourselves on any row of a dynaset. When positioned in the middle of a dynaset (current row is not the last row), we navigate to the next row using DbMoveNext.

However, when we are positioned on the last row (current row is the last row) and then execute DbMoveNext, the end-of-file condition (EOF) becomes TRUE and current row becomes invalid. In this case, we reset the current row using the DbMoveLast method.

The click event procedure for our Next button looks like:

Private Sub cmdNext_Click()

EmpDynaset.MoveNext

If EmpDynaset.EOF = True Then

MsgBox WarnLastEmp$

EmpDynaset.MoveLast

End If

Call EmpRefresh

End Sub


 
Oracle
Copyright copy; 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents