DbiForceReread

C syntax

DBIResult DBIFN DbiForceReread (hCursor);

Delphi syntax

function DbiForceReread (hCursor: hDBICur): DBIResult stdcall;

Description

DbiForceReread refreshes all buffers for the table associated with the cursor in case remote updates took place.

Parameters

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

Usage

DbiForceReread is used to ensure that the client application is using current data. All subsequent retrieval operations will get new data.

Note:

This function ensures only that the buffered data is current at the time of the call. Periodically use DbiForceReread or DbiCheckRefresh to ensure current data. Use record locking to prevent other users from updating records being modified by this cursor.

Note: This function is supported only on cursors for DbiOpenTable and "live" local (Paradox, FoxPro, Access, or dBASE) query cursors. "Dead" table cursors, and tables with no unique index are not supported.

Alternatively you can use DbiForceRecordReread to reread a single record from the server on demand, refreshing one row only, rather than clearing the cache.

In order to notify the client application that the table data was actually changed by a remote user, a callback of the type cbTABLECHANGED can be installed. This callback will be invoked whenever a change is detected.

Prerequisites

SQL: There must be a unique row identifier such as an index.

DbiResult	Meaning
DBIERR_NONE	Buffers were refreshed successfully.
DBIERR_INVALIDHNDL	The specified cursor handle is invalid or NULL.