PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Disables a trigger. Then, this trigger can be re-enabled by HActivateTrigger.
Reminder: A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a HFSQL function is run. A trigger is defined by HDescribeTrigger. See Managing the triggers for more details.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// In the initialization code of the project
LOCAL
TriggerResult is boolean

// Create a trigger for all the analysis files
TriggerResult = HDescribeTrigger("*", "HADD,HMODIFY," + ...
"HDELETE, HCROSS,HWRITE", "CheckUserRights", hTriggerBefore)
// "CheckUserRights" is a global procedure of the project
IF TriggerResult = False THEN
Error("Error on a trigger: " + HErrorInfo)
RETURN
END

...
// Disables the trigger for all the files
// On HDelete and HCross
HDeactivateTrigger("*", "HDELETE,HCROSS")
Syntax
<Result> = HDeactivateTrigger([<List of Files> [, <List of Functions>]] [, <Type>])
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HError is used to identify the error.
<List of Files>: Optional character string (with quotes)
Logical name of one or more data files.
To specify several names of data files, the names of the data files must be separated by a comma (",").
To use all the analysis files, this parameter must be equal to "*".

By default, all the data files are taken into account.
<List of Functions>: Optional character string (with quotes)
Name of one or more HFSQL or TableXXX 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 Functions> is set to "*", all the HFSQL functions that can activate a trigger are taken into account.

By default, all the HFSQL functions that can activate a trigger are taken into account.
<Type>: Optional Integer constant
Indicates the type of trigger. All the triggers are affected if this parameter is not specified.
hTriggerBeforeThe procedure is run before the HFSQL function
hTriggerAfterThe procedure is run after the HFSQL function
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
Windows Mobile wp230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment