Close method: SQL class

Syntax

Close()

Description

The Close method closes the SQL object. This terminates any incomplete fetching of select result rows, completes any buffered operations (that is, using BulkMode), and disassociates the SQL object from any SQL statement that was open on it.

After BulkMode operations, the RowsAffected property is not valid.

Parameters

None

Returns

True on successful completion, False if there was a duplicate record error. Any errors associated with buffered operations (that is, using BulkMode), other than duplicate record errors, cause termination.

Example

&SQL = CreateSQL("%Delete(:1)");
While /* Still something to do */
   /* Set key field values of &ABS_HIST */
   &SQL.Execute(&ABS_HIST);
End-While;
&SQL.Close();