PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App This property is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Define the deletion rule used in the OrdLine link
OrdLine..DeletionRule = hIntegrityForbidden
...
// Validates the file description
HDescribeFile(OrdLine)
Syntax

Finding out the deletion rule Hide the details

<Deletion Rule> = <Link Name>..DeletionRule
<Deletion Rule>: Integer constant
The different deletion rules are as follows:
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.
hIntegrityCascadeCascading deletion: all the linked records are deleted in cascade 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.
hIntegrityDefaultValueDefault Deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.
<Link Name>: 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

<Link Name>..DeletionRule = <Deletion Rule>
<Link Name>: 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:
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.
hIntegrityCascadeCascading deletion: all the linked records are deleted in cascade 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.
hIntegrityDefaultValueDefault Deletion: the linked keys are initialized with their default value when the key item is deleted from the source file.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment