PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • 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.
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.
Example
MaConnexion is Connection
MaLiaison is Link Description
// Description de la liaison "HABITE"
MaLiaison.SourceFile = ".\ville.fic"
MaLiaison.LinkedFile = ".\client.fic"
MaLiaison.SourceKey = "NOMVILLE"
MaLiaison.LinkedKey = "VILLECLI"
 
// Liaison par défaut (0-1, 0-1)
HDeleteLink(MaConnexion, MaLiaison)
// Supprimer toutes les liaisons d'une base de données
// d'un serveur HFSQL Client/Serveur
// indépendamment de l'analyse en cours
CnxHFSQL is Connection
CnxHFSQL.Provider = hAccessHFClientServer
CnxHFSQL.User = "admin"
CnxHFSQL.MotDePasse = ""
CnxHFSQL.Server = "HFSQLServeur:4900"
CnxHFSQL.Database = "CRM"
HOpenConnection(CnxHFSQL)
 
sListeLiaisons is string = HListLink("*", CnxHFSQL)
sInfoUneLiaison is string
UneLiaison is Link Description
 
FOR CHAQUE STRING sInfoUneLiaison OF sListeLiaisons SÉPARÉE BY CR
IF sInfoUneLiaison <> "" THEN
UneLiaison.Name = ExtractString(sInfoUneLiaison, 1, TAB)
UneLiaison.SourceFile = Replace(ExtractString(sInfoUneLiaison, 2, TAB), ...
CnxHFSQL.Database, ".", IgnoreCase)
UneLiaison.SourceKey = ExtractString(sInfoUneLiaison, 3, TAB)
UneLiaison.LinkedFile = Replace(ExtractString(sInfoUneLiaison, 5, TAB), ...
CnxHFSQL.Database, ".", IgnoreCase)
UneLiaison.LinkedKey = ExtractString(sInfoUneLiaison, 6, TAB)
// Suppression de la liaison du serveur HFSQL Client/Serveur
Trace("Suppression >> " + UneLiaison.Name + " >> " + ...
HDeleteLink(CnxHFSQL, UneLiaison))
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 delete is defined by the source data file, the source item and the linked item.
Remarks

Link description

  • During the description of the link, the names of the data files involved in the link (SourceFile and LinkedFile properties) must correspond to the physical names of the data files, relative to the database concerned. 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 data file used in the link.
    SourceKeyItem of the source data file used in the link.
    LinkedFileName of the linked data file used in the link.
    SourceFileName of the source data file used in the link.
    NameLink name.
Component: wd260hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment