PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
HCloseConnection (Function)
In french: HFermeConnexion
ODBCNot available with this kind of connection
Closes a connection to a database. All the data files that are using this connection are closed.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
// Describe and open the new connection
HDescribeConnection("MyConnection", "", "", "Server_SQLServer", ...
"dbo", hODBC, hOReadWrite, "")
HOpenConnection("MyConnection")

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

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

// Close the connection
HCloseConnection("MyConnection")
Syntax
<Result> = HCloseConnection(<Connection name>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Connection name>: Character string (with quotes)
Name of connection to a database. This connection was defined in the data model editor or by HDescribeConnection. You also have the ability to use a Connection variable.
Remarks
The description of the connection must be known when running HCloseConnection.
Component : wd240hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Example
https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/3252-informatica-novo-metodo-create-database-hfsql-client-server-3266/read.awp
BOLLER
29 Jul. 2019