Objeck Classes

All Bundles

ParameterStatement

ODBC parametrized statement that supports SQL variables

Operations

Close
Select
SetBit
SetBlob
SetBytes
SetDate
SetDouble
SetInt
SetReal
SetSmallInt
SetTimestamp
SetVarchar
Update

Close

Closes the statement

method : public : Close() ~ Nil

Select

Executes a SQL select statement

method : public : Select() ~ ResultSet

Return

Type	Description
ResultSet	result set

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