PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

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: The HFSQL databases do not allow you to open several connections. Nesting connections is only available for the databases that use an access via ODBC, OLE DB, or via a Native Access. The Native AS/400 Access allows you to nest the maximum number of connections allowed by the license.
Versions 16 and later
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). See Accessing a database in local mode (SQLite) for more details.
New in version 16
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). See Accessing a database in local mode (SQLite) for more details.
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). See Accessing a database in local mode (SQLite) for more details.
Versions 18 and later
WEBDEV - Server codePHP This function is now available for the PHP sites.
New in version 18
WEBDEV - Server codePHP This function is now available for the PHP sites.
WEBDEV - Server codePHP This function is now available for the 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 : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment