<Source>.DeleteTrigger (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.DeleteTrigger (Function)

In french: <Source>.DétruitTrigger

Available only with this kind of connection

Deletes a trigger. This trigger cannot be used anymore.

Reminder: A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever an HFSQL function is run. A trigger is defined by <Source>.DescribeTrigger. For more details, see Managing the triggers

Syntax

<Result> = <Source>.DeleteTrigger([<List of HFSQL functions>] [, <Type>])

<Result>: Boolean

True if the operation was performed,
False if a problem occurs. HError is used to identify the error.

<Source>: Type corresponding to the specified source

Logical name of an HFSQL data file.

<List of HFSQL functions>: Optional character string

Name of one or more HFSQL functions on which the trigger must be implemented. To specify several names of functions, the names of functions must be separated by a comma (","). You have the ability to define triggers on the following HFSQL functions:
<Source>.Modify
<Source>.Add
<Source>.Delete
<Source>.Write
<Source>.Cross
If <List of HFSQL functions> is set to "*", all the HFSQL functions used to activate a trigger are taken into account.
By default; <List of HFSQL functions> = "*".

<Type>: Optional Integer constant

Type of trigger:
hTriggerAfter The procedure is run after the HFSQL function.
hTriggerBefore The procedure is run before the HFSQL function.

All triggers are affected if this parameter is not specified.

Component: wd300hf.dll