v2025.6.2
All Bundles

ResultSet

ODBC result set

Operations

Close

Closes a result set

method : public : Close() ~ Nil

GetBit

Gets a bit value

method : public : GetBit(column:Int) ~ Bool

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Boolbit value

GetBit

Gets a bit value

method : public : GetBit(column:String) ~ Bool

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Boolbit value

GetBlob

Gets a blob value

method : public : GetBlob(column:Int, buffer:Byte[]) ~ Nil

Parameters

NameTypeDescription
columnIntcolumn ID
bufferBytebuffer to write into

GetBlob

Gets a blob value

method : public : GetBlob(column:String, buffer:Byte[]) ~ Nil

Parameters

NameTypeDescription
columnStringcolumn name
bufferBytebuffer to write into

GetColumnInfo

Get the metadata for a given column

method : public : GetColumnInfo() ~ ColumnInfo[]

Return

TypeDescription
ColumnInfocolumn metadata

GetDate

Gets a date value

method : public : GetDate(column:Int) ~ Database.ODBC.Date

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Database.ODBC.Datedate value

GetDate

Gets a date value

method : public : GetDate(column:String) ~ Database.ODBC.Date

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Database.ODBC.Datedate value

GetDouble

Gets a double value

method : public : GetDouble(column:Int) ~ Float

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Floatdouble value

GetDouble

Gets a double value

method : public : GetDouble(column:String) ~ Float

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Floatdouble value

GetInt

Gets an integer value

method : public : GetInt(column:Int) ~ Int

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Intinteger value

GetInt

Gets an integer value

method : public : GetInt(column:String) ~ Int

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Intinteger value

GetReal

Gets a real value

method : public : GetReal(column:Int) ~ Float

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Floatreal value

GetReal

Gets a real value

method : public : GetReal(column:String) ~ Float

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Floatreal value

GetSmallInt

Gets a small integer value

method : public : GetSmallInt(column:Int) ~ Int

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Intsmall integer value

GetSmallInt

Gets a small integer value

method : public : GetSmallInt(column:String) ~ Int

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Intsmall integer value

GetTimestamp

Gets a timestamp value

method : public : GetTimestamp(column:Int) ~ Timestamp

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Timestamptimestamp value

GetTimestamp

Gets a timestamp value

method : public : GetTimestamp(column:String) ~ Timestamp

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Timestamptimestamp value

GetVarchar

Gets a varchar value

method : public : GetVarchar(column:Int) ~ String

Parameters

NameTypeDescription
columnIntcolumn ID

Return

TypeDescription
Stringvarchar value

GetVarchar

Gets a varchar value

method : public : GetVarchar(column:String) ~ String

Parameters

NameTypeDescription
columnStringcolumn name

Return

TypeDescription
Stringvarchar value

IsNull

Checks to see if the value fetched is NUL. This method should be called after a value is fetched using GetX(column).

method : public : IsNull() ~ Bool

Return

TypeDescription
Booltrue if NIL, false otherwise

Next

Moves the cursor to the next row in the result set

method : public : Next() ~ Bool

Return

TypeDescription
Booltrue if cursor was moved, false otherwise