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.

Help / WLanguage / Managing databases / SQL functions

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 the connection specified with SQLChangeConnection.

Important HFSQL databases do not allow multiple connections to be opened 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.

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).

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