DeletionRule (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content comes from an automatic translation.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

DeletionRule (Property)

In french: RègleSuppression

..DeletionRule is used to configure the deletion rule (integrity management) of records that will be applied to the file described by programming. You can:

Find out the deletion rule used for a file defined in the analysis or by programming.
Define the deletion rule used for a file (when the link is described by programming).

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store apps mode.

New in version 18

This property is now available in Windows Store apps mode.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Define the deletion rule used in the OrdLine link
OrdLine..DeletionRule = hIntegrityForbidden
...
// Validate the file description
HDescribeFile(OrdLine)

Syntax

Finding out the deletion rule Hide the details

<Deletion Rule> = <Name of the link>..DeletionRule

<Deletion Rule>: Integer constant

The different deletion rules are as follows:
hIntegrityNone No integrity management: no specific action is performed in the linked file when the key item is deleted from the source file of the link.
hIntegrityCascade Cascading deletion: all the linked records are deleted in cascade when the key item is deleted from the source file.
hIntegrityForbidden Deletion not allowed: the key item cannot be deleted from the source file if the record is linked to another record.
hIntegrityDefaultValue Default Deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.

<Name of the link>: Character string (with or without quotes)

Name of the link defined in the analysis or by the Link Description type.

Defining the deletion rule used in the link defined by programming Hide the details

<Name of the link>..DeletionRule = <Deletion Rule>

<Name of the link>: Character string (with or without quotes)

Name of the link used. This name was defined by the Link Description type.

<Deletion Rule>: Integer constant

The different deletion rules are as follows:
hIntegrityNone No integrity management: no specific action is performed in the linked file when the key item is deleted from the source file of the link.
hIntegrityCascade Cascading deletion: all the linked records are deleted in cascade when the key item is deleted from the source file.
hIntegrityForbidden Deletion not allowed: the key item cannot be deleted from the source file if the record is linked to another record.
hIntegrityDefaultValue Default Deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.