ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Reindexing
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HIndexingInProgress (Function)
In french: HRéindexationEnCours
HFSQL ClassicHFSQL Client/ServerAvailable 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.
WEBDEV - Server code This parameter is not taken into account.
Remarks

Reindexing

The indexes are reorganized by the reindex operation. The data cannot be accessed during the reindex operation.
WINDEV 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.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/04/2023

Send a report | Local help