PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • The same trigger is applied to several files or to several WLanguage functions
  • Compatibility with the earlier versions
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
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
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.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Retrieve the triggers applied to "Customer" and "Product" files
ListTriggers is string
ListTriggers = HListTrigger("Customer,Product")

// Adds the list of triggers into COMBO_COMBO1
ListAdd(COMBO_COMBO1, ListTriggers)
Syntax
<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 + <Status of Trigger> + 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).
<Trigger Status>
<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 (",").
Remarks
WINDEVWEBDEV - Server codeReports and QueriesWindows MobileUniversal Windows 10 AppUser code (UMC)HFSQLHFSQL Client/ServerHyper File 5.5OLE DBODBCNative Accesses

The same trigger is applied to several files or to several WLanguage functions

If a trigger (described by HDescribeTrigger) is applied to several data files or to several WLanguage functions, this trigger will be displayed several times in the list (according to the number of HFSQL functions and/or data files).
Example 1: a trigger is applied to several data files:
// Describes a trigger applied to "Customer" and "Product" files
HDescribeTrigger("Customer,Product", "HAdd", "CheckParam", hTriggerBefore)
MyList is string = HListTrigger()

// The content of MyList will be as follows:
// Customer  <TAB>  CheckParam  <TAB>  HAdd  <TAB>  A  <TAB>  1
// Product  <TAB>  CheckParam  <TAB>  HAdd  <TAB>  A  <TAB>  1
Example 2: a trigger is applied to several HFSQL functions:
// Describes a trigger applied to HAdd and HModify
HDescribeTrigger("CUSTOMER", "HAdd,HModify", "CheckParam", hTriggerAfter)
MyList is string = HListTrigger()
// The content of MyList is as follows:
// CUSTOMER  <TAB>  CheckParam  <TAB>  HAdd  <TAB>  P  <TAB>  1
// CUSTOMER  <TAB>  CheckParam  <TAB>  HModify <TAB>  P  <TAB>  1

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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Linux wd230hf.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment