Move the current record position in the AdoRecordset
by the specified number of records.
Move(nRecords As Long, [vStart As Variant])
|nRecords||(Long) The number of records that the current record position moves. Greater than zero means forward and less than zero means backward.|
|vStart||[optional] (Variant) Define the starting position (Bookmark). If not defined, the starting position will be the position of the current active record. If a valid Bookmark is defined, it will be used as starting position. It is also possible to use standard numeric constants for defining the start position:|
0 (default) - (adBookmarkCurrent) Current record.
1 - (adBookmarkFirst) First record.
2 - (adBookmarkLast) Last record.
Reading the data over the PmAdo
object ("/TestAdoDb"), that is already connected to the database (see DbOpen
), using the SQL
query ("SELECT * FROM table1"). The resulting AdoRecordset
object will be stored by the PmAdo
object with the defined unique identifier ("table1"), as static
. It will be checked if errors occured and the method returned a valid AdoRecordset
object. Then it will go through the records of the AdoRecordset
object and the value of the first column of each 10th record
will be written into the INFO system.