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 an 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.