PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Creating a link
  • Notes
  • Owner file and member file
  • Referential integrity
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
Overview
The links are used to link the date files described in an analysis between themselves.
Several types of links are available. See Types of links for more details.
Reminder: The "LDM" and "Analysis" terms are indifferently used to define the structure of the database associated with a project.
Creating a link
To create a link:
  1. Select "Insert .. Link". The mouse cursor turns into a pen.On the "Analysis" pane, in the "Creation" group, click "New link". The mouse cursor turns into a pen.
  2. Click the two data files that must be linked. The wizard for link description is automatically opened.
  3. To define the cardinalities between the two files:
    • select the cardinalities among the proposed ones (0, 1; 1, 1; 0, N; 1, N).
    • answer the questions asked. The cardinalities will be automatically updated.
  4. To define the advanced cardinalities, check "Display the advanced cardinalities" and answer the questions asked.
  5. Type the link caption by briefly describing the purpose of the link. Go to the next step.
  6. Specify the keys to link. Go to the next step.
  7. Define the integrity rules. These rules are used to ensure the data integrity when one of the relation keys is modified or deleted.
  8. Validate. The link is automatically created.
Notes:
  • See Cardinalities for more details.
  • Versions 16 and later
    If the data files to link contain an identical unique composite key (and also contain the items included in the composite key), a link can be performed on this composite key.
    New in version 16
    If the data files to link contain an identical unique composite key (and also contain the items included in the composite key), a link can be performed on this composite key.
    If the data files to link contain an identical unique composite key (and also contain the items included in the composite key), a link can be performed on this composite key.
Notes

Owner file and member file

When a link is defined between two data files, an owner file and a member file are found:
  • the owner file is the owner of the key.
  • the member file is a member of the analysis files containing a copy of the key.
To manage the link between two data files, the key of the owner file is copied into the member file.
For example, the key of "Supplier" file is copied into each record of "Product" file. Several records of "Product" file can have the same key of "Supplier" file:
  • the owner file is"Supplier",
  • the member file is "Product".
This type of link is represented as follows:

Referential integrity

The referential integrity of a database corresponds to the respect of constraints implied by the links between the data files.
The referential integrity consists in checking that:
  • if a record is deleted from the owner file, the corresponding records are also deleted from the member files,
  • if a record is added into a member file, a corresponding record exists in the owner file,
  • if a record is modified in the owner file, the unique key is not modified,
  • ...
The check of referential integrity depends on the nature of the link between the data files.
Related Examples:
WD Reflexive link Training (WINDEV): WD Reflexive link
[ + ] This example presents the management of a reflexive link with the WLanguage functions.
The following topics are presented in this example:
1/ Fill a control with HFSQL content (automatic management of reflexive link).
2/ Fill by programming.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment