SQLChangeConnection (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLChangeConnection (Function)

In french: SQLChangeConnexion

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

This function is now available in 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

This function is now available in 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.

This function is now available in 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

This function is now available for the PHP sites.

New in version 18

This function is now available for the PHP sites.

This function is now available for the PHP sites.

Versions 19 and later

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

New in version 19

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for the Android applications (accessing the external databases via a Webservice).

This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

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 : wd240hf.dll