SQLChangeConnection (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

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: 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 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). For more details, see Accessing a database in local mode (SQLite).

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). For more details, see Accessing a database in local mode (SQLite).

This function is now available in Browser code.

The SQL functions are used to handle the local databases (such as Web SQL databases). For more details, see Accessing a database in local mode (SQLite).

Versions 18 and later

This function is now available for PHP sites.

New in version 18

This function is now available for PHP sites.

This function is now available for 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 Android applications (accessing the external databases via a Webservice).

This function is now available for 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 Android applications (accessing the external databases via a Webservice).

This function is now available for 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 Android applications (accessing the external databases via a Webservice).

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

// Les clients sont sur une base ORACLE
Conn1 is int = SQLConnect("ORACLE", "", "")
// La comptabilité est sur une base SQLSERVER
Conn2 is int = SQLConnect("SQLSERVER", "", "")
...
// Accéder aux clients
SQLChangeConnection(Conn1)
...
// Accéder à la comptabilité
SQLChangeConnection(Conn2)
...
// Fermeture de la connexion en cours
SQLDisconnect()
// Fermeture de la connexion en cours
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