base.SqlHandle methods

Table 1. Class methods
Name Description
base.SqlHandle.create()
  RETURNS 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 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(
   position 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()
 RETURNS INTEGER
Returns the number of result set columns produced by the SQL statement.
getResultName( index INTEGER )
 RETURNS STRING
Returns the name of a column in the result set produced by the SQL statement.
getResultType( index INTEGER )
 RETURNS STRING
Returns the Genero type name of a column in the result set produced by the SQL statement.
getResultValue( index INTEGER )
 RETURNS 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 STRING )
Prepares an SQL statement for the SQL handle.
put()
Put a new row in the insert cursor buffer.
setParameter(
   index INTEGER,
   value primitive-type )
Sets the value of an SQL parameter for this SQL handle.
setParameterType(
   index INTEGER,
   type STRING )
Defines the type of an SQL parameter for this SQL handle.