base.SqlHandle.close
Closes the SQL handle (cursor).
Syntax
close()Usage
Call the close() method when you are finished using the SQL handle as a cursor
opened with the open()
method.
The statement can be re-opened after it has been closed.
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.