PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

This content comes from an automatic translation.
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.
Remark: 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>)
<Result>: Boolean
  • True if the operation was performed,
  • False if a problem occurred. HErrorInfo is used to identify the error.
<Connection>: Character string (with quotes) or Connection variable
Connection to a database. This connection corresponds to:
PHP This parameter must correspond to the name of the connection enclosed in quotes. No Connection variable can be used.
Remarks
The description of the connection must be known when running HCloseConnection.
Component : wd250hf.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