TotalRecords

Applies to:

Description

Returns the number of records contained in the Pervasive.SQL file associated with the VAccess control.

Remarks

Since the total number of records may change due to other users, retrieving this value forces a Stat call in order to ensure an accurate record count. As a result, properties that reflect aspects of the status buffer will be overwritten by this property. Properties affected include PageSize, PercentFreeSpace, PreallocatedPages, and ReservedDupPointers. Additionally, performing this on a remote file will cause a stat request to be performed at the remote site, which may slow down the application.

Example

Dim NumRecords as Long  
NumRecords = VAccess1.TotalRecords 

See Also:

Affects: PageSize

Affected by: Stat