ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing triggers / WLanguage functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HCreateServerTrigger (Function)
In french: HCréeTriggerServeur
HFSQL Client/ServerAvailable only with this kind of connection
Adds or modifies a server trigger on the HFSQL server. To perform these operations:
  • The trigger must have been previously described in the analysis.
  • The stored procedure released by the trigger must exist on the server. This procedure can be updated by HUpdateSet.
This function is used to update the HFSQL server without having to perform an automatic data update.
Reminder: The server triggers are stored procedures run by the server before or after a write operation performed on a database file. For more details, see Server triggers.
Example
HCreateServerTrigger(ClientTrigger)
Syntax
<Result> = HCreateServerTrigger(<Trigger>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HErrorInfo is used to identify the error.
<Trigger>: Character string
Name of the server trigger to create. This trigger was described in the analysis.
If this parameter corresponds to "*", all the triggers described in the analysis will be created.
Remarks
The server triggers described in the analysis can be updated via the automatic data modification.
Business / UI classification: Business Logic
Component: wd290hf.dll
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help