DbGetNoRecs                                                                                        Function

 

DBGETNORECS(dbName as Database)

 

Description

Returns the number of records in a database. The database must have been previously opened with DBOPEN. Returns an integer result.

 

Example

Dim res as Integer

Res=DbGetNoRecs(OrdersDb) 'res has the number of records

If res>0 then

  res=dbPosition(OrdersDb, res, 0) 'position to last record

  res=dbGet(OrdersDb, OrderKey) 'order key has highest key in database

end if