DBMove Action

Moves the cursor to the first, last, next, or previous record in a Recordset object.

Use

When the current record is the last record in a Recordset object, moving to the next record will position the cursor after the last record and the EOF property will be set to True. When the EOF property is True, moving to the next record will generate an error.

When the current record is the first record in a Recordset object, moving to the previous record will position the cursor before the first record and the BOF property will be set to True. When the BOF property is True, moving to the previous record will generate an error.

Moving to the first or last record in a Recordset object generates an error if both the BOF and EOF properties are True, i.e. the Recordset object contains no records.

Parameters

Recordset  -  (Required)

Specifies the name of the Recordset object in which the cursor should be moved.

Move Option  -  (Required)

Specifies how the cursor should move in the Recordset object. Use one of the following pre-defined Move Option constants.

ClosedExample

The following example connects to an Access database and uses the DBFind action to search the open recordset for a value saved in the variable varSearch.

Connect

DBConnect (testConnection, DBServerADO, Provider=Microsoft.Jet.OLEDB.4.0; Data Source=@test\crm.mdb; Mode=Share Deny None; Persist Security Info=False;)

DBOpen (recordset1, testConnection, Table1, DBUseClient, DBOpenDynamic, DBLockReadOnly, DBCmdTable)

Find

DBMove (recordset1, DBMoveFirst)

DBFind (recordset1, ="EntityRef = " & varSearch, DBFindForward)

recordset1.EOF = False MsgBox(Found, =varSearch & " was found.", MsgInformation, MsgOKOnly)

recordset1.EOF = True MsgBox(Not Found, =varSearch & " was not found.", MsgCritical, MsgOKOnly)

 

Close

DBClose (recordset1)

DBDisconnect (testConnection)

StopMacro

See Also

DBConnect Action | DBDisconnect Action | DBOpen Action | DBClose Action | DBFind Action | DBMove Action | DBAddNew Action | DBBeginTrans Action | DBCancelUpdate Action | DBCommitTrans Action | DBDelete Action | DBRollbackTrans Action | DBSeek Action | DBUpdate Action

© 2004-2022 looksoftware. All rights reserved.