Returns the list of triggers applied to one or more HFSQL data files. Reminder
: A trigger is a WLanguage procedure automatically called whenever one or more HFSQL functions are run. See Managing the triggers
for more details
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
// Retrieve the triggers applied to "Customer" and "Product" files
ListTriggers is string
ListTriggers = HListTrigger("Customer,Product")
// Adds the list of triggers into COMBO_COMBO1
<Result> = HListTrigger([<Name of files>])
<Result>: Character string
List of triggers applied to the specified data files. The different triggers are separated by CR characters (Carriage Return).
The list has the following format:
<File name> + TAB + <Procedure name> + TAB +
<Name of HFSQL function> + TAB + <Type of trigger> +
TAB + <Trigger status> + CR +...
|<File name>||Data file onto which the trigger is applied.|
|<Procedure name>||WLanguage procedure called by the trigger.|
|<Name of HFSQL function>||HFSQL function onto which the trigger applied.|
|<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).
<Name of files>: Optional character string (with quotes)
Name of one or more data files. If this parameter is not specified, the triggers of all the data files found in the analysis associated with the current project will be listed.
To specify several names, the names of the data files must be separated by a comma (",").
Compatibility with the earlier versions
The following syntax is kept for backward compatibility:
<Result> = HListTrigger([<File name> [,<Full WDD name>]])
The <Full WDD name> parameter is kept for backward compatibility. This parameter is ignored.
Business / GUI classification : Business Logic