<Source>.ListLink (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Displaying the result in a List Box or Combo Box control

Deletion and modification rule

See also

<Source>.ListLink (Function)

In french: <Source>.ListeLiaison

Not available with this kind of connection

Returns the list of a data file links (Merise type) present in the current analysis or in a specific analysis.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for Java applications.

Example

// Retrieve the links of the Customer data file in the current analysis
ListLink is string
ListLink = Customer.ListLink(hLstDétail)
// Adds the list of links in COMBO_COMBO1
COMBO_COMBO1.Add(ListLink)

Syntax

List the a data file relationships present in an analysis Hide the details

<Result> = <Source>.ListLink([<Path of WDD> [, <Password of WDD>]] [, <Options>])

<Result>: Character string

List of links. The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used:
hLstDetail is not specified <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +...
hLstDetail is specified <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +...

Where:
<Name link X>: name of the link.
<Name file x.1>:: Name of the data file related to the primary key.
<Name item x.1>: Name of the item related to the primary key or name of the specified data file.
<Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
<Name file x.2>: Name of the data file related to the foreign key.
<Name item x.2>: Name of the item related to the foreign key.
<Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
<Modification rule>: Rule to apply if the primary key is modified.
<Deletion rule>: Rule to apply if the primary key is deleted.
The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
If one of the listed links is performed in a composite key, the <Name item 1.2> parameter returned will correspond to the name of the different key components. The names will be separated by a comma.

<Source>: Type corresponding to the specified source

Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.

<Path of WDD>: Optional character string

Full path of the analysis file (.WDD file). If this parameter is not specified or if it is equal to an empty string (""), the links are sought in the current analysis.

<Password of WDD>: Optional character string

Password defined for the analysis. If no password is defined, this parameter must be equal to an empty string ("").

<Options>: Optional integer constant

Type of list to perform:
hLstDetail Lists the detailed information about the links.
hLstNormal
(default value) Lists the links.
This parameter is ignored.

List the a data file links accessible via a Native Connector or OLE DB connection or via an HFSQL Client/Server connection Hide the details

<Result> = <Source>.ListLink([<Connection>] [, <Options>])

<Result>: Character string

List of links. The different link descriptions are separated by CR characters (Carriage Return). The result is more or less detailed depending on the constant used:
hLstDetail is not specified <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + CR +...
hLstDetail is specified <Name link1> + TAB + <Name file1.1> + TAB + <Name item1.1> + TAB + <Cardinality 1.1> + TAB + <Name file1.2> + TAB + <Name item1.2> + TAB + <Cardinality 1.2> + TAB + <Modification rule> + TAB + <Deletion rule> + CR +...

Where:
<Name link X>: name of the link.
<Name file x.1>:: Name of the data file related to the primary key.
<Name item x.1>: Name of the item related to the primary key or name of the specified data file.
<Cardinality x.1>: Cardinality of the link related to the primary key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
<Name file x.2>: Name of the data file related to the foreign key.
<Name item x.2>: Name of the item related to the foreign key.
<Cardinality x.2>: Cardinality of the link related to the foreign key in the following format: "<Min cardinality>, <Max cardinality>" ("0, N" or "1, N" for example).
<Modification rule>: Rule to apply if the primary key is modified (see Remarks).
<Deletion rule>: Rule to apply if the primary key is deleted (see Remarks).
The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
If one of the listed links is performed in a composite key, the <Name item 1.2> parameter returned will correspond to the name of the different key components. The names will be separated by a comma.

<Source>: Type corresponding to the specified source

Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.

<Connection>: Character string (with or without quotes) or Connection variable

Connection to use. This connection corresponds to:
either to the name of the connection defined in the analysis editor or thanks to the HDescribeConnection or HOpenConnection functions.
or in the name of an Variable of the type Connection.

<Options>: Optional integer constant

Type of list to perform:
hLstDetail Lists the detailed information about the links.
hLstNormal
(default value) Lists the links.
This parameter is ignored.

Remarks

Displaying the result in a List Box or Combo Box control

<Result> can be directly assigned to a List Box or Combo Box control by <List Box>.Add. Each row will contain the full name of one of the links found.

Deletion and modification rule

The modification rules and the deletion rules returned by <Source>.ListLink can correspond to the following constants:


hIntegrityNone	No integrity constraint.
hIntegrityCascade	Manage the cascading modification and deletion.
hIntegrityForbidden	Strict respect of integrity.
hIntegrityDefaultValue	During the deletion, a default value is assigned to the linked records.

Component: wd260hf.dll