ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • How to describe a link through programming?
  • List of HFSQL properties used to describe a link through programming
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
Describes a link between two data files through programming.
After the call to HDescribeLink:
  • The description of the link is validated.
  • The link description cannot be modified anymore.
  • The variable for link description is reinitialized. A new link description can be done.
Remark: To add a relationship to an HFSQL Client/Server database, use HAddLink.
Example
HDescribeLink(CustomerProductLink)
Syntax
<Result> = HDescribeLink(<Link>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurs. HErrorInfo is used to identify the error.
<Link>: Link Description variable
Name of the Link description variable that corresponds to the link to create.
Remarks

How to describe a link through programming?

To describe a link through programming, you must:
  1. Use the Link description variables.
  2. Describe the characteristics of the link via the HFSQL properties.
  3. Use HDescribeLink to save the description of the link.
Remark: To describe a data file through programming, use HDescribeFile. To describe items through programming, use HDescribeItem.

List of HFSQL properties used to describe a link through programming

The following properties are available in read/write mode.
DeletionRuleThe DeletionRule property is used to configure the deletion rule (integrity management) to be applied to the data file described through programming.
LinkedFileThe LinkedFile property is used to set the characteristics of a link.
LinkedKeyThe LinkedKey property is used to set the characteristics of a link
MaxLinkedCardinalityThe MaxLinkedCardinality property is used to get and modify the maximum cardinality of the related item in the link.
MaxSourceCardinalityThe MaxSourceCardinality property gets and changes the maximum cardinality of the source item in the link.
MinLinkedCardinalityThe MinLinkedCardinality property is used to get and modify the minimum cardinality of the related item in the link.
MinSourceCardinalityThe MinSourceCardinality property is used to get and modify the minimum cardinality of the source item in the link.
ModificationRuleThe ModificationRule property is used to configure the modification rule (integrity management) to be applied to the data file described in the code.
NameThe Name property is used to get:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
SourceFileThe SourceFile property is used to set the characteristics of a link.
SourceKeyThe SourceKey property is used to set the characteristics of a link.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/26/2023

Send a report | Local help