Oracle Objects for OLE
Release 8.1.7

Part Number A85257-01

Library

Product

Contents

Moving to the Previous 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 first row), we navigate to the previous row using DbMovePrevious.

However, when we are positioned on the first row (current row is the first row) and then execute DbMovePrevious, the beginning-of-file (BOF) condition becomes TRUE and the current row becomes invalid. In this case, we reset the current row to the first row using DbMoveFirst.

The click event procedure for our Previous button looks like:

Private Sub cmdPrevious_Click()

EmpDynaset.MovePrevious

If EmpDynaset.BOF = True Then

MsgBox WarnFirstEmp$

EmpDynaset.MoveFirst

End If

Call EmpRefresh

End Sub


 
Oracle
Copyright copy; 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents