Home

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
TypeDescription
ResultSetresult set

SetBit

Sets a bit type to NULL

method : public : SetBit(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a bit type

method : public : SetBit(pos:Int, value:Bool) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueBoolbit value

Return
TypeDescription
Booltrue if set, false otherwise

SetBlob

Sets a blob type to NULL

method : public : SetBlob(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a blob type

method : public : SetBlob(pos:Int, buffer:Byte[]) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
bufferByte[]byte buffer

Return
TypeDescription
Booltrue if set, false otherwise

SetBytes

Sets a stream of bytes

method : public : SetBytes(pos:Int, buffer:Byte[], length:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
bufferByte[]byte buffer
lengthIntnumber of bytes to write

Return
TypeDescription
Booltrue if set, false otherwise

SetDate

Sets a date type to NULL

method : public : SetDate(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a date type

method : public : SetDate(pos:Int, value:Date) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueDatedate value

Return
TypeDescription
Booltrue if set, false otherwise

SetDouble

Sets a double type to NULL

method : public : SetDouble(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a double type

method : public : SetDouble(pos:Int, value:Float) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueFloatdouble value

Return
TypeDescription
Booltrue if set, false otherwise

SetInt

Sets a integer type to NULL

method : public : SetInt(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a integer type

method : public : SetInt(pos:Int, value:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueIntinteger value to set

Return
TypeDescription
Booltrue if set, false otherwise

SetReal

Sets a real type to NULL

method : public : SetReal(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a real type

method : public : SetReal(pos:Int, value:Float) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueFloatreal value

Return
TypeDescription
Booltrue if set, false otherwise

SetSmallInt

Sets a small integer type to NULL

method : public : SetSmallInt(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a small integer type

method : public : SetSmallInt(pos:Int, value:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueIntsmall integer value

Return
TypeDescription
Booltrue if set, false otherwise

SetTimestamp

Sets a timestamp type to NULL

method : public : SetTimestamp(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets a timestamp type

method : public : SetTimestamp(pos:Int, value:Timestamp) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueTimestamptimestamp value

Return
TypeDescription
Booltrue if set, false otherwise

SetVarchar

Sets varchar type to NULL

method : public : SetVarchar(pos:Int) ~ Bool
Parameters
NameTypeDescription
posIntparameter position

Return
TypeDescription
Booltrue if set, false otherwise

Sets varchar type

method : public : SetVarchar(pos:Int, value:String) ~ Bool
Parameters
NameTypeDescription
posIntparameter position
valueStringstring value

Return
TypeDescription
Booltrue if set, false otherwise

Update

Executes a SQL update statement. Statement is closed after calling.

method : public : Update() ~ Int
Return
TypeDescription
Intresult code