PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
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
Modifies the current connection. The current connection corresponds to the last opened connection or to the connection specified by SQLChangeConnection.
Important: HFSQL databases do not allow to open multiple connections simultaneously. Connection nesting can only be used for bases using ODBC, OLE DB, or Native Connector access.. The Native Connector AS/400 allows the maximum number of connections allowed by the license to be nested.
Versions 18 and later
PHP This function is now available for PHP sites.
New in version 18
PHP This function is now available for PHP sites.
PHP This function is now available for PHP sites.
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: wd260hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment