ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
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
DeletionRule (Property)
In french: RègleSuppression
The DeletionRule property is used to configure the deletion rule (integrity management) to be applied to the data file described programmatically. You can:
  • Find out the deletion rule used for a data file defined in the analysis or programmatically
  • Define the deletion rule used for a data file (only for dynamic links defined programmatically).
Example
// Defines the deletion rule used in the OrdLine link
OrdLine.DeletionRule = hIntegrityForbidden
...
// Validate the data file description
HDescribeFile(OrdLine)
Syntax

Finding out the deletion rule Hide the details

<Deletion rule> = <Link>.DeletionRule
<Deletion rule>: Integer constant
The different deletion rules are as follows:
hIntegrityCascadeCascading delete: all the linked records are deleted in cascade when the key item is deleted from the source file.
hIntegrityDefaultValueDefault deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.
hIntegrityForbiddenDeletion not allowed: the key item cannot be deleted from the source file if the record is linked to another record.
hIntegrityNoneNo integrity management: no specific action is performed in the linked file when the key item is deleted from the source file of the link.
<Link>: Character string
Name of the link defined in the analysis or by the Link Description type.

Defining the deletion rule used in the link defined programmatically Hide the details

<Link>.DeletionRule = <Deletion rule>
<Link>: Character string
Name of the link used. This name is defined with the Link Description type.
<Deletion rule>: Integer constant
The different deletion rules are as follows:
hIntegrityCascadeCascading delete: all the linked records are deleted in cascade when the key item is deleted from the source file.
hIntegrityDefaultValueDefault deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.
hIntegrityForbiddenDeletion not allowed: the key item cannot be deleted from the source file if the record is linked to another record.
hIntegrityNoneNo integrity management: no specific action is performed in the linked file when the key item is deleted from the source file of the link.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/17/2024

Send a report | Local help