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
HListServerTrigger (Function)
In French: HListeTriggerServeur
Lists the different triggers available on a connection or on one of the connection files.
Note: The functions for handling the server triggers are advanced functions. The server triggers can be created directly in the data model editor. See Server triggers for more details.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Syntax
<Result> = HListServerTrigger(<Connection Name> [, <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 Name> + TAB + <Physical File Name> + TAB + <Procedure Name> + TAB +
<Function Number> + TAB + <Type of Trigger> + TAB + <Trigger Status> + CR +...
<Trigger Name>Name of trigger.
<Physical File Name>Data file onto which the trigger is applied.
<Procedure Name>WLanguage stored 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\" sub-directory 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 Name>: Character string (with or without quotes)
Name of connection to use. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Physical HFSQL Client/Server Files>: Optional character string (with quotes)
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 if it corresponds to an empty string (""), the trigger will be enabled on all the data files of the database.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment