9.48 DELETE_TRIGGERS
Deletes standard DICTIONARY or FILE level triggers from a nominated field for subsequent replacement by the PUT_TRIGGER Built-In Function.
When deleting FILE level triggers from a field, the file involved must have been previously placed into an edit session by the START_FILE_EDIT Built-In Function.
Normal authority and task tracking rules apply to the use of this Built-In Function.
This is a Specialized Built-In Function for use in a Development Environment only.
Arguments
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | Req | Level of triggers that are to be deleted. D = Dictionary level F = File level | 1 | 1 | ||
2 | A | Req | Name of field in dictionary or file from which triggers are to be deleted. | 1 | 10 | ||
3 * | N | Req | Sequence number to control deletion. Only triggers with a sequence number greater than or equal to this value are deleted. If this argument is not specified, a value of zero (0) is assumed, so all triggers will match this control value. | 1 | 3 | 0 | 0 |
4 * | A | Req | Generic description of trigger used to control deletion. Only checks which have a description generically matching this value will be deleted. If this value is not specified, a default value of blanks is assumed, so all checks will match this control value. | 1 | 30 |
* The deletion control sequence number and description are related by an "AND" relationship. So if you pass values of 500 and 'IEW', only triggers that have a sequence number greater than or equal to 500 and a description that starts with 'IEW' will be deleted.
Return Values
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | Req | Return code OK = validation check defined ER = fatal error detected NR = no records found eligible for deletion In case of "ER" return code error message(s) are issued automatically. When a file edit session is involved it is ended automatically without commitment. | 2 | 2 |