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) that will be applied to the data file described by programming. You can:
  • Find out the deletion rule used for a data file defined in the analysis or by programming
  • Define the deletion rule used for a data file (during dynamic link description by programming only).
Example
// Define 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:
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>: 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>..DeletionRule = <Deletion rule>
<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:
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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment