Home

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

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
bufferByte[]buffer to write into

Gets a blob value

method : public : GetBlob(column:String, buffer:Byte[]) ~ Nil
Parameters
NameTypeDescription
columnStringcolumn name
bufferByte[]buffer to write into

GetDate

Gets a date value

method : public : GetDate(column:Int) ~ Date
Parameters
NameTypeDescription
columnIntcolumn ID

Return
TypeDescription
Datedate value

Gets a date value

method : public : GetDate(column:String) ~ Date
Parameters
NameTypeDescription
columnStringcolumn name

Return
TypeDescription
Datedate value

GetDouble

Gets a double value

method : public : GetDouble(column:Int) ~ Float
Parameters
NameTypeDescription
columnIntcolumn ID

Return
TypeDescription
Floatdouble value

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

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

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

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

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

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