PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Closes a connection to a database. All data files using this connection are closed.
Versions 16 and later
Android This function is now available for Android applications.
New in version 16
Android This function is now available for Android applications.
Android This function is now available for Android applications.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android widget mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android widget mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// 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:
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 whenHCloseConnection is executed.
Component: wd270hf.dll
See also
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