Help / WLanguage / Managing databases / HFSQL / WLanguage variables
  • Value of H.AutoIndexingLimit
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
H.AutoIndexingLimit (Variable)
In french: H.LimiteRéindexationAutomatique
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Indicates the maximum number of records in the data file used to manage the automatic reindexing.
As long as this number is not reached, the HFSQL engine starts the automatic reindexing if an index error occurs.
Reminder: No automatic reindexing is available for the data files in Hyper File 5.5 format.

Value of H.AutoIndexingLimit

  • The H.AutoIndexingLimit variable is set to 100.000 by default.
  • If H.AutoIndexingLimit is set to 0, the automatic reindexing is disabled.
  • If H.AutoIndexingLimit is initialized with a negative value, the value of this variable will automatically correspond to the default value.
Caution: If a lock error occurs during the reindex operation (when the data file or a record found in the data file is locked in read/write for example), the automatic re-indexing is stopped and a fatal error (corrupted index) is displayed. Then, you will have to reindex the data file.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 07/05/2023

Send a report | Local help