Apollo API Listing > sx

VB Declaration

Declare Function sx_Count Lib "Apollo9.dll" () As Long

C Declaration

LONG FAR PASCAL sx_Count (VOID);

Description

Extracts the number of records in the table. This function respects the setting of all filters, scopes, query bitmaps, conditional indexes, and the setting of sx_SetDeleted. It is the only count function that returns a completely accurate count of records depending upon all of the possible conditions that may be imposed on the table. It is also the slowest count function.

Return Value

The record count according to every possible condition imposed upon the table.

VB Example

' Display table info

Text4.Text = sx_BaseDate()

Text5.Text = sx_RecSize()

Text6.Text = sx_Count() ' logical count

Text7.Text = sx_QueryRecCount() ' quickest count

Text8.Text = sx_RecCount() ' physical count