DbiRegenIndexes

C syntax

DBIResult DBIFN DbiRegenIndexes (hCursor);

Delphi syntax

function DbiRegenIndexes (hCursor: hDBICur): DBIResult stdcall;

Description

DbiRegenIndexes regenerates all indexes associated with a cursor.

Parameters

hCursor Type: hDBICur (Input)
Specifies the cursor handle for the table to be regenerated.

Usage

A maintained index is automatically updated when the table is updated.

dBASE or FoxPro: All open indexes are regenerated.

Paradox: All maintained and non-maintained indexes are regenerated.

SQL, Access: SQL and Access indexes cannot be regenerated.

Prerequisites

There can be more than one index open on a table. A valid cursor handle must be obtained, the table must be opened exclusively, and the index must already exist.

DbiResult	Meaning
DBIERR_NONE	All of the indexes for the table associated with the specified cursor have been successfully regenerated.
DBIERR_INVALIDHNDL	The specified cursor handle is invalid or NULL.
DBIERR_NEEDEXCLACCESS	The table associated with hCursor is opened in open shared mode.
DBIERR_NOTSUPPORTED	SQL indexes cannot be regenerated.