ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • HSecurity and HFlush
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
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.
Example
HSecurity(False) // Disables the protection mechanism
HSecurity(True) // Enables the protection mechanism
Syntax
<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 handles all the data files described in the analysis.
Hyper File 5.5 This parameter is ignored. The security is enabled for all the data files found in the current analysis.
<Security level>: Integer or boolean
Requested security level:
  • 0 or False (by default): the security mechanism is disabled. The speed of the write-to-file operations is maximum.
  • 1 or True: The security mechanism is enabled: The speed of the write-to-file operations is slower than when using HSecurity(0) but the security is ensured when writing into the data files.
  • 2: Maximum security mechanism: The speed of write-to-file operations is slower than when using HSecurity(1).
Remarks

HSecurity and HFlush

HSecurity and HFlush can both be used to force a physical write operation on disk.
However:
  • HSecurity forces the data file(s) to be written. This write operation is automatically performed by the HFSQL engine. The data files used are not closed during this write operation. The speed of the write-to-file operation is slower.
  • HFlush is used to force a write operation into the data files handled during the call to this function. The data files used are closed then re-opened during this write operation. The speed of the write-to-file operation is not slowed down.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/19/2023

Send a report | Local help