SQLClose - cSQLStatement

Close the statement handle and free the DataFlex statement handle object.

Type: Procedure

Syntax

Procedure SQLClose

Call Example

Send SQLClose

Description

This procedure will call the Connectivity Kit's close function and free the DataFlex statement object.

Use SQLOpen and cSQLStatement to allocate and de-allocate statement handles. You need to close a statement handle whenever the statement changes.

Sample

Handle hoSQLMngr
Handle hDbc hStmt

Object oSQLHandler is a cSQLHandleManager
    Move Self to hoSQLMngr
End_Object

Open Customer
Get SQLFileConnect of hoSQLMngr Customer.File_number to hDbc
Get SQLOpen of hDbc to hStmt
Send DoSomeEmbeddedSQLStuff hStmt
Send SQLClose of hStmt
Send SQLDisconnect of hDbc