PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Link description
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
HDeleteLink (Function)
In French: HSupprimeLiaison
HFSQL Client/ServerAvailable only with this kind of connection
Deletes an integrity rule between two data files on the server. The integrity rule to delete is defined by a Link Description variable.
The deletion will be effective for the application that performed it once the connection has been closed and re-opened.
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.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 22
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
MyLink is Link Description
// Describe the "LIVES" link
MyLink..SourceFile = ".\city.fic"
MyLink..LinkedFile = ".\customer.fic"
MyLink..SourceKey = "CITYNAME"
MyLink..LinkedKey = "CUSTCITY"


// Default link (0-1, 0-1)
HDeleteLink(MyConnection, MyLink)
// Delete all links from a database
// found on a HFSQL Client/Server server
// 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)

sListLinks is string = HListLink("*", CntHFSQL)
sALinkInfo is string
ALink is Link Description

FOR EACH STRING sALinkInfo OF sListLinks SEPARATED BY CR
IF sALinkInfo <> "" THEN
ALink..Name = ExtractString(sALinkInfo, 1, TAB)
ALink..SourceFile = Replace(ExtractString(sALinkInfo, 2, TAB), ...
CntHFSQL..Database, ".", IgnoreCase)
ALink..SourceKey = ExtractString(sALinkInfo, 3, TAB)
ALink..LinkedFile = Replace(ExtractString(sALinkInfo, 5, TAB), ...
CntHFSQL..Database, ".", IgnoreCase)
ALink..LinkedKey = ExtractString(sALinkInfo, 6, TAB)
// Delete the link from the HFSQL Client/Server server
Trace("Deletion >> " + ALink..Name + " >> " + ...
HDeleteLink(CntHFSQL, ALink))
END
END
Syntax
<Result> = HDeleteLink(<Source Connection> [, <Linked Connection>] , <Link Description>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Source Connection>: Character string (with or without quotes)
Name of connection to which belongs the source file of link. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
<Linked Connection>: Optional character string (with or without quotes)
Name of connection to which the linked file of link belongs. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
If this parameter is not specified, the two data files belong to the same connection (<Source Connection>).
<Link Description>: Link description
Name of the Link description variable containing the characteristics of the link to delete. The link to delete is defined by the source file, the source item and the linked item.
Remarks

Link description

  • When describing the link, the names of the data files involved in the link (..SourceFile and ..LinkedFile) must correspond to the physical name of the files, relative to the relevant database. The database of each data file is returned by the <Source Connection> and <Linked Connection> parameters.
  • To delete a link, there is no need to describe all the characteristics of the link. Only the following properties are required:
    LinkedKeyItem of the linked file used in the link.
    SourceKeyItem of source file used in the link.
    LinkedFileName of the linked file used in the link.
    SourceFileName of the source file used in the link.
    NameName of the link.
Components
WINDEVWEBDEV - Server code wd230hf.dll
Windows Mobile wp230hf.dll
Linux wd230hf.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment