All Bundles
ParameterStatement
ODBC parametrized statement that supports SQL variables
Operations
Close
Closes the statement
method : public : Close() ~ Nil
Select
Executes a SQL select statement
method : public : Select() ~ ResultSet
Return
SetBit
Sets a bit type to NULL
method : public : SetBit(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a bit type
method : public : SetBit(pos:Int, value:Bool) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Bool | bit value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetBlob
Sets a blob type to NULL
method : public : SetBlob(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a blob type
method : public : SetBlob(pos:Int, buffer:Byte[]) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
buffer | Byte[] | byte buffer |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetBytes
Sets a stream of bytes
method : public : SetBytes(pos:Int, buffer:Byte[], length:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
buffer | Byte[] | byte buffer |
length | Int | number of bytes to write |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetDate
Sets a date type to NULL
method : public : SetDate(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a date type
method : public : SetDate(pos:Int, value:Date) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Date | date value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetDouble
Sets a double type to NULL
method : public : SetDouble(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a double type
method : public : SetDouble(pos:Int, value:Float) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Float | double value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetInt
Sets a integer type to NULL
method : public : SetInt(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a integer type
method : public : SetInt(pos:Int, value:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Int | integer value to set |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetReal
Sets a real type to NULL
method : public : SetReal(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a real type
method : public : SetReal(pos:Int, value:Float) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Float | real value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetSmallInt
Sets a small integer type to NULL
method : public : SetSmallInt(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a small integer type
method : public : SetSmallInt(pos:Int, value:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Int | small integer value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetTimestamp
Sets a timestamp type to NULL
method : public : SetTimestamp(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets a timestamp type
method : public : SetTimestamp(pos:Int, value:Timestamp) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | Timestamp | timestamp value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
SetVarchar
Sets varchar type to NULL
method : public : SetVarchar(pos:Int) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Sets varchar type
method : public : SetVarchar(pos:Int, value:String) ~ Bool
Parameters
Name | Type | Description |
---|
pos | Int | parameter position |
value | String | string value |
Return
Type | Description |
---|
Bool | true if set, false otherwise |
Update
Executes a SQL update statement. Statement is closed after calling.
method : public : Update() ~ Int
Return
Type | Description |
---|
Int | result code |