dbCount ( )

Retrieves the record count (row count) for a table

Usage:

dbCount (object me, string tableName)

Parameter:

tableName - (string) the name of the table in the data file. Use dbTableFieldNames( ) to obtain the list of tables available in your data file.

Returns:

(integer) - total row count in the table

Example:

xtRose = xtra("Rosetta").new()
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
rowCount = xtRose.dbCount( "MSysAccessObjects" )

Notes:

It may be useful to obtain the record count before calling dbTableData() to ensure that you have adequate memory.