base.SqlHandle.close
Closes the SQL handle (cursor).
Syntax
close()
Usage
Call the close()
method when you are finished using the SQL handle.
The statement can be re-opened after it has been closed.
Note: A SqlHandle object is automatically closed when the object is destroyed.
As with standard Genero SQL instructions, SQL errors can be trapped
with WHENEVER ERROR
or TRY / CATCH
blocks and by testing
SQLCA.SQLCODE
.
Example
DEFINE sh base.SqlHandle
...
CALL sh.close()
For a complete example, see Example 2: SqlHandle with result set SQL.