DbRecordCount

ODBC function.

The DbRecordCount function returns the number of records in the dataset in use. Not available in WinTask Lite.

Syntax

num=DbRecordCount()

Return value

Num, number of records.

Example

 

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

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

counter=DbRecordCount() ' count the number of records present in dataset.

msgbox(str$(counter)) 'display result