Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • HSecurity and HFlush functions
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
HSecurity (Function)
In french: HSécurité
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Enables or disables the automatic security mechanism on one or more data files.
HSecurity(False) // Disables the protection mechanismHSecurity(True) // Enables the protection mechanism
<Result> = HSecurity([<Data file>, ] <Security level>)
<Result>: Integer
Former security level (before running HSecurity).
<Data file>: Optional character string
Name of the data file used.
If this name is not specified, HSecurity manipulates all the data files defined in the analysis.
Hyper File 5.5 This parameter is ignored. Security is enabled for all data files in the current analysis.
<Security level>: Integer or boolean
Requested security level:
  • 0 or False (by default): The security mechanism is disabled. Data is written to data files at the highest speed possible.
  • 1 or True: The security mechanism is enabled: Write speed is slower than with HSecurity(0), but security is guaranteed.
  • 2: Maximum security mechanism: Write speed is slower than with HSecurity(1).

HSecurity and HFlush functions

HSecurity and HFlush can both be used to force a physical write operation on disk.
  • HSecurity forces the data file(s) to be written. The HFSQL engine automatically performs the write operation. The data files are not closed during this write operation. This results in slower write speeds.
  • HFlush forces a write operation to the data files when it is called. The data files are closed and then re-opened during this write operation. The write operation is not slowed down.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment

Last update: 03/14/2024

Send a report | Local help