PC SOFT

ONLINE HELP
 WINDEVWEBDEV 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
Modifies the current connection. The current connection corresponds to the last opened connection or the connection specified with SQLChangeConnection.
Important: HFSQL databases do not allow to open multiple connections simultaneously. Nesting connections is only available for databases using an access via ODBC, OLE DB, or Native Connectors. The Native AS/400 Connector enables the maximum number of connections allowed by the license.
Example
// The customers are found on an ORACLE database
Conn1 is int = SQLConnect("ORACLE", "", "")
// The accounting is found on an SQLSERVER database
Conn2 is int = SQLConnect("SQLSERVER", "", "")
...
// Access the customers
SQLChangeConnection(Conn1)
...
// Access the accounting
SQLChangeConnection(Conn2)
...
// Close the current connection
SQLDisconnect()
// Close the current connection
SQLDisconnect()
Syntax
<Result> = SQLChangeConnection(<Connection number>)
<Result>: Boolean
  • True if the change of connection was performed,
  • False otherwise.
<Connection number>: Integer
Number of the connection to use, returned by SQLConnect.
Component: wd270hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment