base.SqlHandle methods

Table 1. Class methods
Name Description
create()
 RETURNING handle base.SqlHandle
Create a new base.SqlHandle object.
Table 2. Object methods
Name Description
close()
Closes the SQL handle (cursor).
execute()
Executes a simple SQL statement (without result set).
fetch()
Fetches a new row from the SQL result set.
fetchAbsolute(position INTEGER)
Fetches to a specified row in a scrollable SQL result set.
fetchFirst()
Fetches the first row in a scrollable SQL result set.
fetchLast()
Fetches the last row in a scrollable SQL result set.
fetchPrevious()
Fetches the previous row in a scrollable SQL result set.
fetchRelative(offset INTEGER)
Fetches a row relative to the current row in a scrollable SQL result set.
flush()
Flushes the rows from the insert cursor buffer.
getResultCount()
 RETURNING count INTEGER
Returns the number of result set columns produced by the SQL statement.
getResultName( index INTEGER )
 RETURNING name STRING
Returns the name of a column in the result set produced by the SQL statement.
getResultType( index INTEGER )
 RETURNING type STRING
Returns the Genero type name of a column in the result set produced by the SQL statement.
getResultValue( index INTEGER )
 RETURNING value fgl-type
Returns the value of a column in the result set produced by the SQL statement.
open()
Opens the SQL handle (SELECT or INSERT cursor).
openScrollCursor()
Opens the SQL handle (with scrollable option).
prepare( sql-text STRING )
Prepares an SQL statement for the SQL handle.
put()
Put a new row in the insert cursor buffer.
setParameter(
   index INTEGER,
   value fgl-type )
Sets the value of an SQL parameter for this SQL handle.