ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
HListServerTrigger (Function)
In french: HListeTriggerServeur
Lists the different triggers available on a connection or on one of the connection files.
Note Server trigger manipulation functions are advanced functions. The server triggers can be created directly in the data model editor. For more details, see Server triggers.
Syntax
<Result> = HListServerTrigger(<Connection> [, <Physical HFSQL Client/Server files>])
<Result>: Character string
List of server triggers applied to the specified connection. The different triggers are separated by CR characters (Carriage Return).
The list has the following format:
<Trigger> + TAB + <Data file> + TAB + <WLanguage procedure> + TAB +
<Function number> + TAB + <Type of trigger> + TAB + <Trigger status> + CR +...
<Trigger>Name of trigger.
<Data file>Physical name of the data file to which the trigger applies.
<WLanguage procedure>Name of the stored WLanguage procedure called by the trigger.
<Function number>Identifier of WLanguage function on which the server trigger is enabled.
To find out the name of WLanguage function used, see the ListeDéfinitionHF.WL file (found in the "Personal\External\" subdirectory of WINDEV, WINDEV Mobile or WEBDEV).
<Type of trigger>
  • "A" for a "BEFORE" trigger (the procedure associated with the trigger is run before the HFSQL function of trigger).
  • "P" for an "AFTER" trigger (the procedure associated with the trigger is run after the HFSQL function of trigger).
<Trigger status>
<Connection>: Optional character string or Connection variable
Connection to use. This connection corresponds to:
<Physical HFSQL Client/Server files>: Optional character string
Physical name of one or more HFSQL Client/Server data files associated with the connection ("CUSTOMER.FIC" for example). To specify several names, the names of the data files must be separated by a comma (",").
If this parameter is not specified or is an empty string (""), the trigger will be enabled on all the data files of the database.
Component: wd300hf.dll
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/12/2025

Send a report | Local help