HAddLink (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Link description
Miscellaneous

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HAddLink (Function)

In french: HAjouteLiaison

Available only with this kind of connection

Adds an integrity rule between two data files on the server. This integrity rule has been previously described by a variable of type Link description. All the client applications must comply with these integrity rules.

Remark: It is possible to describe inter-base integrity rules.

The addition will be effective for the application that performed it once the connection has been closed and re-opened.

Example

// Description de la connexion
HDescribeConnection("MaConnexion", "Julie", "MotDePasse", "MonServeurHF", ...
	"MaBaseDeDonnées", hAccessHFClientServer, hORead)
// Ouverture de la connexion
HOpenConnection("MaConnexion")
...
MaLiaison is Link Description
// Description de la liaison "HABITE"
MaLiaison.Nom = "HABITE"
MaLiaison.FichierSource = ".\MaBase\ville.fic"
MaLiaison.FichierRelié = ".\MaBase\client.fic"
MaLiaison.CléSource = "NOMVILLE"
MaLiaison.CléReliée = "VILLECLI"
// Liaison par défaut (0-1, 0-1)
HAddLink("MaConnexion", MaLiaison)

Syntax

<Result> = HAddLink(<Source connection> [, <Linked connection>] , <Link>)

<Result>: Boolean

True if the operation was performed,
False if a problem occurs. HErrorInfo is used to identify the error.

<Source connection>: Character string or Connection variable

Connection to which belongs the source file of the link. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
a variable of type Connection.

<Linked connection>: Optional character string or Connection variable

Connection to which belongs the linked file of the link. This connection corresponds to:
the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
a variable of type Connection.
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.

Remarks

Link description

In the link description, 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 used. The Database of each file is returned by <Source connection> and <Linked connection>.

Miscellaneous

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).
HDeleteLink is used to delete a link on the server.

Component: wd300hf.dll