ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
ModificationRule (Property)
In french: RègleModification
The ModificationRule property is used to configure the modification rule (integrity management) to be applied to the table described in the code. You can:
  • Find out the modification rule used for a table defined in the database schema or programmatically.
  • Define the modification rule used for a table (when the link is described through programming).
Example
// Define the modification rule used in the OrdLine link
OrdLine.ModificationRule = hIntegrityForbidden
...
// Validate the table description
HDescribeTable(OrdLine)
Syntax

Finding out the modification rule Hide the details

<Modification rule> = <Link>.ModificationRule
<Modification rule>: Integer constant
The different modification rules are as follows:
hIntegrityCascadeCascading modification: modification of the key field in the source file results in cascading modification of all linked records.
hIntegrityDefaultValueDefault modification: when the key field is modified in the source file, the linked keys are initialized by their default value.
hIntegrityForbiddenModification forbidden: the key field in the source file cannot be modified if the record is linked to a record.
hIntegrityNoneNo integrity management: modification of the key field in the link source file does not lead to any specific action in the linked file.
<Link>: Character string
Name of the link defined in the database schema or by the Link Description type.

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

<Link>.ModificationRule = <Modification rule>
<Link>: Character string
Name of the link defined in the database schema or by the Link Description type.
<Modification rule>: Integer constant
The different modification rules are as follows:
hIntegrityCascadeCascading modification: modification of the key field in the source file results in cascading modification of all linked records.
hIntegrityDefaultValueDefault modification: when the key field is modified in the source file, the linked keys are initialized by their default value.
hIntegrityForbiddenModification forbidden: the key field in the source file cannot be modified if the record is linked to a record.
hIntegrityNoneNo integrity management: modification of the key field in the link source file does not lead to any specific action in the linked file.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/13/2025

Send a report | Local help