base.SqlHandle.put

Put a new row in the insert cursor buffer.

Syntax

put()

Usage

Call the put() method to create a new row for the insert cursor.

The SQL statement must have been prepared with a prepare() call.

All SQL parameter values must be provided before doing the put() 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.put()

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