The DbMoveNext function moves the read pointer to the previous record of the recordset in use .
ret, optional numeric return value. If the move has been performed successfully, the return value is 0. If the function fails, the return value is a nonzero value (see Error Codes for Database Functions).
'The example uses a data source name called DBTest which contains those records in a table called DATA:
' a,1, 1.23, 02/01/2011
' b,2, 2.34, 03/02/2012
' c,3, 3.45, 04/12/2009
DbConnect("DSN=DBTest") ' connection to ODBC database called DBTest
DbSelect("SELECT * FROM DATA",DYNASET) ' select all records in table DATA
DbMove(2) 'move read pointer to the 2nd record
DbMovePrev() 'move read pointer to the previous record (the 1st record)