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.
Versions 19 and later
Android Widget This function is now available in Android widget mode (accessing external databases via a Webservice).
Android This function is now available for Android applications (accessing external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).
New in version 19
Android Widget This function is now available in Android widget mode (accessing external databases via a Webservice).
Android This function is now available for Android applications (accessing external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).
Android Widget This function is now available in Android widget mode (accessing external databases via a Webservice).
Android This function is now available for Android applications (accessing external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing external databases via a Webservice).
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.
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