base.SqlHandle.flush

Flushes the rows from the insert cursor buffer.

Syntax

flush()

Usage

With an insert cursor, call the flush() method to force the buffered rows to the database server.

The SQL statement must have been opened with a open() call.

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.flush()

For a complete example, see Example 3: SqlHandle with insert cursor.