DbMove

ODBC function.

The DbMove function moves the read pointer to the specified record for the dataset in use. Not available in WinTask Lite.

Syntax

DbMove(<pos>)
or
Ret=DbMove(<pos>)

Parameter

<pos>, mumeric, indicates how many records the read pointer must move to get to the desired record. A positive value moves the pointer toward the end of the dataset, a negative value moves the pointer toward the beginning of the dataset.

Return value

Ret, numeric return code. If the move has been performed successfully, the function returns 0, otherwise use this return code for error management.

Example

 

DbConnect("DSN=gpao;PWD=SILOG") ' connection to ODBC database called gpao

DbSelect("SELECT * FROM Business",DYNASET) ' select all records in table Business.

DbMove(5) ' move read pointer to the 5th record.