PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
  • 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. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
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) or Connection variable
Connection to which belongs the source file of the link. This connection corresponds to:
<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 description>: Link Description variable
Name of the Link description variable containing the characteristics of the link to delete. The link to be deleted is defined by the source data file, the source field, as well as the related field.
Remarks

Link description

  • When describing the link, the names of the data files participating in the link (properties ..SourceFile and ..LinkedFile) must correspond to the physical name of data file, relative to the database in question. The database associated with each data file is known by the parameters <Source Connection> and <Connected Connection>.
  • To delete a link, there is no need to describe all the characteristics of the link. Only the following properties are required:
    LinkedKeyConnected data file field used in the link.
    SourceKeySource data file field used in the link.
    LinkedFileName of the linked data file used in the link.
    SourceFileName of the source data file used in the link.
    NameName of the link.
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment