Skip to content

SQLDisconnect Command

Obsolete

Refer to the SQLDisconnect method in the cSQLConnection class.

SQLDisconnect hdbc

The SQLDisconnect command closes a connection.

  • If it was created by the SQLConnect command, all associated resources will be freed and the connection is actually closed.
  • If the connection was already in use, i.e., SQLFileConnect was used to obtain the handle, the embedded SQL resources of the connection are freed but the connection itself will not be closed.
Open Customer
SQLFileConnect Customer To hdbc
SQLOpen hdbc To hstmt
SQLExecDirect hstmt "UPDATE CUSTOMER SET AccntMngr = 'John' WHERE AccntMngr = 'Mary'"
SQLClose hstmt
SQLDisconnect hdbc