ResultSet
ODBC result set
Operations
- Close
- GetBit
- GetBlob
- GetColumnInfo
- GetDate
- GetDouble
- GetInt
- GetReal
- GetSmallInt
- GetTimestamp
- GetVarchar
- IsNull
- Next
GetBit
Gets a bit value
method : public : GetBit(column:Int) ~ BoolParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Bool | bit value |
GetBit
Gets a bit value
method : public : GetBit(column:String) ~ BoolParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Bool | bit value |
GetBlob
Gets a blob value
method : public : GetBlob(column:Int, buffer:Byte[]) ~ NilParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
| buffer | Byte | buffer to write into |
GetBlob
Gets a blob value
method : public : GetBlob(column:String, buffer:Byte[]) ~ NilParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
| buffer | Byte | buffer to write into |
GetColumnInfo
Get the metadata for a given column
method : public : GetColumnInfo() ~ ColumnInfo[]Return
| Type | Description |
|---|---|
| ColumnInfo | column metadata |
GetDate
Gets a date value
method : public : GetDate(column:Int) ~ Database.ODBC.DateParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Date | date value |
GetDate
Gets a date value
method : public : GetDate(column:String) ~ Database.ODBC.DateParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Date | date value |
GetDouble
Gets a double value
method : public : GetDouble(column:Int) ~ FloatParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Float | double value |
GetDouble
Gets a double value
method : public : GetDouble(column:String) ~ FloatParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Float | double value |
GetInt
Gets an integer value
method : public : GetInt(column:Int) ~ IntParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Int | integer value |
GetInt
Gets an integer value
method : public : GetInt(column:String) ~ IntParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Int | integer value |
GetReal
Gets a real value
method : public : GetReal(column:Int) ~ FloatParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Float | real value |
GetReal
Gets a real value
method : public : GetReal(column:String) ~ FloatParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Float | real value |
GetSmallInt
Gets a small integer value
method : public : GetSmallInt(column:Int) ~ IntParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Int | small integer value |
GetSmallInt
Gets a small integer value
method : public : GetSmallInt(column:String) ~ IntParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Int | small integer value |
GetTimestamp
Gets a timestamp value
method : public : GetTimestamp(column:Int) ~ TimestampParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| Timestamp | timestamp value |
GetTimestamp
Gets a timestamp value
method : public : GetTimestamp(column:String) ~ TimestampParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| Timestamp | timestamp value |
GetVarchar
Gets a varchar value
method : public : GetVarchar(column:Int) ~ StringParameters
| Name | Type | Description |
|---|---|---|
| column | Int | column ID |
Return
| Type | Description |
|---|---|
| String | varchar value |
GetVarchar
Gets a varchar value
method : public : GetVarchar(column:String) ~ StringParameters
| Name | Type | Description |
|---|---|---|
| column | String | column name |
Return
| Type | Description |
|---|---|
| String | varchar 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() ~ BoolReturn
| Type | Description |
|---|---|
| Bool | true if NIL, false otherwise |
Next
Moves the cursor to the next row in the result set
method : public : Next() ~ BoolReturn
| Type | Description |
|---|---|
| Bool | true if cursor was moved, false otherwise |