ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / WLanguage variables
  • Value of H.AutoIndexingLimit
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
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: Automatic re-indexing is not available for data files in Hyper File 5.5 format.
Remarks

Value of H.AutoIndexingLimit

  • H.AutoIndexingLimit 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.
Warning If a lock error occurs during re-indexing (e.g. when the data file or a record in the data file is locked in read/write mode), automatic re-indexing will be stopped and a fatal corrupted index error will be displayed. Then, you will have to reindex the data file.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help