ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing triggers / WLanguage functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HActivateTrigger (Function)
In french: HActiveTrigger
ODBCNot available with this kind of connection
Re-enables a trigger that was disabled by HDeactivateTrigger.
Reminder: A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever an HFSQL function is run. A trigger is defined by HDescribeTrigger.
Syntax
<Result> = HActivateTrigger([<List of HFSQL data files> [, <List of HFSQL functions>]] [, <Type>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HError is used to identify the error.
<List of HFSQL data files>: Optional character string
Logical name of one or more HFSQL data files.
To specify several names, the names of the data files must be separated by a comma (","). To use all the data files found in the analysis, this parameter must be equal to "*".
By default, <List of HFSQL data files> = "*".
<List of HFSQL functions>: Optional character string
Name of one or more HFSQL functions on which the trigger must be implemented. To specify several names of functions, the names of functions must be separated by a comma (","). You have the ability to define triggers on the following HFSQL functions:If <List of HFSQL functions> is set to "*", all the HFSQL functions used to activate a trigger are taken into account.
By default, <List of HFSQL functions> = "*".
<Type>: Optional Integer constant
Indicates the type of trigger. All triggers are affected if this parameter is not specified.
hTriggerAfterThe procedure is run after the HFSQL function
hTriggerBeforeThe procedure is run before the HFSQL function
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/04/2024

Send a report | Local help