Records in the database, how to display the next article in the previous article (i)

Data | database | Show to move the recordset to the next position in the previous article, let's start by learning the properties and methods of the following Recordset objects:

BOF property: The current cursor refers to the first record of the recordset.
EOF property: The current cursor refers to the last record in the recordset.
Move method: Moves a cursor to a record in the recordset.
AbsolutePosition property: The position of the current cursor in the recordset.
Bookmark attribute: Marks a record of a recordset.

The details are as follows:

BOF and EOF Properties

You can write code to check the BOF and EOF properties to find out where the current cursor Recordset is:

BOF and EOF are false: Indicates that the cursor is in the recordset.
BOF is true: The current cursor refers to the first record of the recordset.
EOF is true: the current cursor refers to the last record in the recordset.
BOF and EOF are true: there is no record of any data in the recordset.
Move method

You can move the cursor to one of the records in the Recordset by moving methods:

MoveFirst method: Moves to the first record.
MoveLast method: Moves to the last record.
MoveNext method: Moves to the next record.
MovePrevious method: Moves to the previous record.
Move [n] Method: Moves the cursor to the nth record, and N is counted as 0.
AbsolutePosition Property

If you need to determine the position of the current cursor in the recordset, you can use the AbsolutePosition property.

The value of the AbsolutePosition property is the position of the current cursor relative to the first, from 1, that is, the absoluteposition of the first article is 1.

However, do not mistakenly assume that AbsolutePosition is the number of the data record, if the current Recordset is in an indeterminate state,

The value of the asoluteposition is