Home | Sign in | English EN

  • Link description
  • Various
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
<Connection variable>.AddLink (Function)
In french: <Variable Connexion>.AjouteLiaison
HFSQL Client/ServerAvailable only with this kind of connection
Adds an integrity rule between two data files on the server. This integrity rule was previously described by a Link description variable. All the client applications must comply with these integrity rules.
Remark: You have the ability to describe inter-database integrity rules.
The addition will be effective for the application that performed it once the connection has been closed and re-opened.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
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.
// Describe the connection
MyConnection is Connection
// Describe the connection
MyConnection..User = "USER"
MyConnection..Password = "PASSWORD"
MyConnection..Server = "MYSERVER"
MyConnection..Database = "Database"
MyConnection..Provider = hAccessHFClientServer
MyConnection..Access = hORead
// Open the connection
MyLink is Link Description
// Describe the "LIVES" link
MyLink..Name = "LIVES"
MyLink..SourceFile = ".\MyDatabase\city.fic"
MyLink..LinkedFile = ".\MyDatabase\customer.fic"
MyLink..SourceKey = "CITYNAME"
MyLink..LinkedKey = "CUSTCITY"
// Default link (0-1, 0-1)
<Result> = <Source connection>.AddLink([<Linked connection>, ] <Link>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Source connection>: Connection variable
Name of the Connection variable that describes the connection to which the link source file belongs.
<Linked connection>: Optional character string (with or without quotes) or Connection variable
Connection to which belongs the linked file of the link. This connection corresponds to: If this parameter is not specified, both data files will belong to the same connection (<Source connection>).
<Link>: Link Description variable
Name of the Link description variable containing the characteristics of the link to create.

Link description

During the description of the link, the names of the data files involved in the link (SourceFile and LinkedFile) must correspond to the physical names of the data files, relative to the relevant Database. The Database of each file is returned by <Source connection> and <Linked connection>


  • HDescribeLink is used to describe a temporary link on an ISAM database (not in Client/Server mode) or for the client application only (not on the server).
  • <Connection variable>.DeleteLink is used to delete a link on the server.
Component: wd260hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment