HIndexingInProgress (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL functions / HFSQL functions

Reindexing
Limitation

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HIndexingInProgress (Function)

In french: HRéindexationEnCours

Available only with these kinds of connection

Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed.

Example

IF HIndexingInProgress(Customer) <> 0 THEN
Trace("Operation unavailable, reindexing")
END

Syntax

<Result> = HIndexingInProgress(<Data file> [, <Progress Bar>])

<Result>: Integer

0 if no reindex operation is in progress on the data file,
an integer included between 1 and 100 indicating the percentage of reindexing already performed

<Data file>: Character string

Name of the data file used.

<Progress Bar>: Optional control or window name, or optional integer

Name of the window in which the gauge is to be displayed, or name of the gauge type field.
Handle of the window that displays the progress bar.
This parameter is not taken into account.

Remarks

Reindexing

The indexes are re-organized by the reindex operation. The data cannot be accessed during the reindex operation.

When accessing a data file on which a reindex operation is performed, the HFSQL engine displays a window indicating that a reindex operation is in progress. This window will be automatically closed at the end of the reindexing.

For more details, see Assisted HFSQL error handling on this window and its customization.

Limitation

This function is not available when using a database via Remote Access.

Component: wd270hf.dll