|
|
|
|
|
|
|
|
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 to open multiple connections 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 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|