Move Method

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

RecordsetObject.Move(MoveOption)

Client support

Newlook Smartclient

Newlook Server

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.

Arguments

Move Option - (Expression, Required)

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

Examples

In the following example we are connecting to an Access database, checking to see if a value exists in the open recordset, then disconnecting the connection.

VB SCRIPT

sConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=@test\crm.mdb;Mode=Share Deny None;Persist Security Info=False"

App.DbConnect "SampleConnection", nlDBServerADO, sConnectString

SampleConnection.Open "SampleRecordset", "Table1", nlDBUseClient, nlDBOpenDynamic, nlDBLockReadOnly, nlDBCmdTable

SampleRecordset.Move nlDBMoveFirst

SampleRecordset.Find "EntityRef =" & App.GetValue("varSearch"),nlDBFindForward

If SampleRecordset.EOF = False then

App.MsgBox App.GetValue("varSearch") & " was found!!!!!", "Found!!!!!", nlMsgInformation, nlMsgOkOnly

else

App.MsgBox "Record was not found", "Alert", nlMsgInformation, nlMsgOkOnly

End If

SampleConnection.Close "SampleRecordset"

SampleConnection.Disconnect

The following functions are used to move the record selection within the open recordset.

JSCRIPT

function navigate (i)

{

try

{

SampleRecordset.Move(i);

if (SampleRecordset.EOF)

SampleRecordset.Move(2);

if (SampleRecordset.BOF)

SampleRecordset.Move(1);

getrecord();

}

catch (e)

{

App.MsgBox(e.name + ": " + e.description, "Error");

}

}

// Update the fields on the form with the details from the current record

function getrecord()

{

App.ActiveForm.CustomerName.Text = SampleRecordset.Fields(0).Value;

App.ActiveForm.CustomerNumber.Text = SampleRecordset.Fields(1).Value;

App.ActiveForm.Street.Text = SampleRecordset.Fields(2).Value;

App.ActiveForm.City.Text = SampleRecordset.Fields(3).Value;

App.ActiveForm.Zip.Text = SampleRecordset.Fields(4).Value;

}

Applies To

DB Recordset object