PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Displaying the result in a list box or in a combo box
  • Deletion and modification rule
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
Returns the list of links (Merise type) found in the current analysis or in a specific analysis.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Example
// Retrieve the links of CUSTOMER file in the current analysis
ListLink is string
ListLink = HListLink(CUSTOMER, hLstDetail)
// Adds the list of links into COMBO_COMBO1
ListAdd(COMBO_COMBO1, ListLink)
// Retrieve the links of a HFSQL Client/Server database
// independently of the current analysis
CntHFSQL is Connection
CntHFSQL..Provider = hAccessHFClientServer
CntHFSQL..User = "admin"
CntHFSQL..Password = ""
CntHFSQL..Server = "HFSQLServer:4900"
CntHFSQL..Database = "CRM"
HOpenConnection(CntHFSQL)
ListLink is string = HListLink("*", CntHFSQL)
// Adds the list of links into COMBO_COMBO1
ListAdd(COMBO_COMBO1, ListLink)
Syntax

Listing the links of an analysis Hide the details

<Result> = HListLink([<File Name> [, <Path of .WDD File> [, <Password of .WDD File> ,]]] [ <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.
HFSQL Client/Server The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
OLE DBNative Accesses 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.
<File Name>: Optional character string (with or without quotes)
Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.
If this parameter is corresponds to "*", HListLink lists the links defined for all the data files defined in the analysis.
<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
Configures the type of list to perform:
hLstDetailLists the detailed information about the links.
hLstNormal
(default value)
Lists the links.
Hyper File 5.5 This parameter is ignored.
WINDEVWEBDEV - Server codeReports and QueriesAjaxUser code (UMC)

Listing the links of a connection via Native Access or via OLE DB or the links of a HFSQL Client/Server connection Hide the details

<Result> = HListLink([<File Name> , <Connection Name> [, <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.
HFSQL Client/Server The name of data files corresponds to the name of the database + '\' + the relative physical name of these data files.
OLE DBNative Accesses 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.
<File Name>: Optional character string (with or without quotes)
Name of the data file whose links must be listed. The links originating from this file or ending at this file are listed.
If this parameter is corresponds to "*", HListLink lists the links defined for all the data files defined in the analysis.
This parameter can correspond to a name unknown to the HFSQL engine, only existing on the database server.
The name of the data file found in first position corresponds to the data file related to the primary key.
<Connection Name>: Optional character string (with or without quotes)
Name of the connection, defined in the data model editor or by programming with HDescribeConnection.
<Options>: Optional integer constant
Configures the type of list to perform:
hLstDetailLists the detailed information about the links.
hLstNormal
(default value)
Lists the links.
Hyper File 5.5 This parameter is ignored.
Remarks

Displaying the result in a list box or in a combo box

<Result> can be directly assigned to a list box or to a combo box by ListAdd. 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 HListLink can correspond to the following constants:
hIntegrityNoneNo integrity constraint.
hIntegrityCascadeManage the cascading modification and deletion.
hIntegrityForbiddenStrict respect of integrity.
hIntegrityDefaultValueDuring the deletion, a default value is assigned to the linked records.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment