|
|
|
|
|
<Connection variable>.DeleteLink (Function) In french: <Variable Connexion>.SupprimeLiaison
Available 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. MyConnection is Connection
MyLink is Link Description
MyLink.SourceFile = ".\city.fic"
MyLink.LinkedFile = ".\customer.fic"
MyLink.SourceKey = "CITYNAME"
MyLink.LinkedKey = "CUSTCITY"
MyConnection.DeleteLink(MyLink)
CntHFSQL is Connection
CntHFSQL.Provider = hAccessHFClientServer
CntHFSQL.User = "admin"
CntHFSQL.Password = ""
CntHFSQL.Server = "HFSQLServer:4900"
CntHFSQL.Database = "CRM"
CntHFSQL.OpenConnection()
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)
UneLiaison.FichierSource = Replace(ExtractString(sInfoUneLiaison, 2, TAB), CnxHFSQL.BaseDeDonnées, ".", IgnoreCase)
ALink.SourceKey = ExtractString(sALinkInfo, 3, TAB)
OneLink.LinkedFile = Replace(ExtractString(sInfoOneLink, 5, TAB), CnxHFSQL.Database, ".", NotCase)
ALink.LinkedKey = ExtractString(sALinkInfo, 6, TAB)
Trace("Deletion >> " + UneLiaison.Nom + " >> " + CnxHFSQL.DeleteLink(UneLiaison))
END
END
Syntax
<Result> = <Source connection>.DeleteLink([<Linked connection>, ] <Link description>)
<Result>: Boolean - True if the operation was performed,
- False if a problem occurs. 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 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 - The names of the data files in the link description (SourceFile and LinkedFile properties) must correspond to the physical name of the data 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:
| | LinkedKey | Item of the linked data file used in the link. | SourceKey | Item of the source data file used in the link. | LinkedFile | Name of the linked data file used in the link. | SourceFile | Name of the source data file used in the link. | Name | Link name. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|