Specifications

• BINARY: character string in unknown encoding, or binary
data, or unsupported data type
Returns the size in bytes needed to store the data in the specified
column (one-based index or column name), or -1 if the size
can’t be determined.
getColumnSize (column :
Number or String ) : Number
Getting the actual data in the result set
Returns true if a row is available for fetching; false otherwise.
This function is used to terminate the iteration over the rows in
the result set.
isRowAvailable( ) : Boolean
Fetches the next available row, making its data values available
for the functions described below.
fetchRow( )
Get functions
The functions described below return the null object (as opposed to an empty string or a zero
number) if:
• The specified column can’t be found.
• There is no currently fetched row.
• The data type for the specified column can’t be converted to the requested data type (see
table in the following section).
• The value in the specified column for the currently fetched row does not conform to the format
for the requested data type.
Returns the value in the specified column for the currently
fetched row as a number.
getNumber( column : Number or
String ) : Number
Returns the value in the specified column for the currently
fetched row as a Date object (date-time value).
getDate( column : Number or
String ) : Date
Returns the value in the specified column for the currently
fetched row as a string.
getString( column : Number or
String , data-codec : String) :
String
The optional codec argument specifies the text encoding
used to convert STRING and BINARY data to a Unicode string.
If the argument is missing or null, latin-1, UTF-16 or the
encoding specified for the connection is used as the default.
For more information see separate section on text encoding
issues.
The codec argument is ignored if the specified column has
a data type other than “STRING” or “BINARY”.
Returns the value in the specified column for the currently
fetched row as a sequence of bytes.
getBinary( column : Number or
String ) : ByteArray
443
Enfocus Switch 10