DbiGetExactRecordCount

C syntax

DBIResult DBIFN DbiGetExactRecordCount (hCursor, piRecCount);

Delphi syntax

function DbiGetExactRecordCount (hCursor: hDBICur; var iRecCount: Longint): DBIResult stdcall;

Description

DbiGetExactRecordCount retrieves the current exact number of records associated with the cursor.

Parameters

hCursor Type: hDBICur (Input)
Specifies the cursor handle.

piRecCount Type: pUINT32 (Output)
Pointer to the client variable which receives the number of records associated with the cursor.

Usage

This function is meant to get the exact number of records associated with the cursor.

Use DbiGetExactRecordCount instead of DbiGetRecordCount if:

1. A filter is active on the specified cursor

2. A range is active on the specified cursor (Paradox tables: use DbiGetRecordCount)

3. A live result is requested on a cursor handle from any of the DbiQ functions

Note:

This function should only be used when necessary. With SQL servers, the entire result set will need to be read to determine the record count which can result in extermely slow responce. An alternative is to use a SELECT COUNT query.

DbiResult	Meaning
DBIERR_NONE	The record count was retrieved successfully.
DBIERR_INVALIDHNDL	The specified cursor handle is invalid or NULL.