HCloseConnection (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HCloseConnection (Function)

In french: HFermeConnexion

Not available with this kind of connection

Closes a connection to a database. All data files using this connection are closed.

Example

See additional examples

// Describe and open the new connection
HDescribeConnection("MyConnection", "", "", "Server_SQLServer", ...
	"dbo", hODBC, hOReadWrite, "")
HOpenConnection("MyConnection")

// Specify that "Salaries" uses the new connection
HChangeConnection("Salaries", "MyConnection")

// Start looping through the "Salaries" table on SQLServer
HReadFirst("Salaries")
...

// Close the connection
HCloseConnection("MyConnection")

Syntax

<Result> = HCloseConnection(<Connection>)

<Result>: Boolean

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

<Connection>: Character string or Connection variable

Connection to a database. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

Remarks

The description of the connection must be known whenHCloseConnection is executed.

Component: wd300hf.dll