TZOracleResultSet Class Reference

Implements Oracle ResultSet. More...

Inheritance diagram for TZOracleResultSet:

TZAbstractResultSet TInterfacedObject IZResultSet

List of all members.

Public Member Functions

 AfterLast ()
 Moves the cursor to the end of this ResultSet object, just after the last row.
 BeforeFirst ()
 Moves the cursor to the front of this ResultSet object, just before the first row.
 CancelRowUpdates ()
 Cancels the updates made to the current row in this ResultSet object.
 ClearWarnings ()
 Clears all warnings reported on this ResultSet object.
 Close ()
 Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
Integer CompareRows (Integer Row1, Integer Row2, const TIntegerDynArray ColumnIndices, const TBooleanDynArray ColumnDirs)
 Compares fields from two row buffers.
 DeleteRow ()
 Deletes the current row from this ResultSet object and from the underlying database.
Integer FindColumn (const string ColumnName)
 Maps the given ResultSet column name to its ResultSet column index.
Boolean First ()
 Moves the cursor to the first row in this ResultSet object.
TStream GetAsciiStream (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
TStream GetAsciiStreamByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
Extended GetBigDecimal (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.
Extended GetBigDecimalByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.
TStream GetBinaryStream (Integer ColumnIndex)
 Gets the value of a column in the current row as a stream of Gets the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes.
TStream GetBinaryStreamByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
IZBlob GetBlob (Integer ColumnIndex)
 Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
IZBlob GetBlobByName (const string ColumnName)
 Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
Boolean GetBoolean (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
Boolean GetBooleanByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.
ShortInt GetByte (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
ShortInt GetByteByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
TByteDynArray GetBytes (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
TByteDynArray GetBytesByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
TZResultSetConcurrency GetConcurrency ()
 Returns the concurrency mode of this ResultSet object.
string GetCursorName ()
 Gets the name of the SQL cursor used by this ResultSet object.
TDateTime GetDate (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
TDateTime GetDateByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.
Double GetDouble (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
Double GetDoubleByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.
TZFetchDirection GetFetchDirection ()
 Returns the fetch direction for this ResultSet object.
Integer GetFetchSize ()
 Returns the fetch size for this ResultSet object.
Single GetFloat (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
Single GetFloatByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.
Integer GetInt (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
Integer GetIntByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.
TZLocateUpdatesMode GetLocateUpdates ()
 Gets an assigned post locate mode.
Int64 GetLong (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
Int64 GetLongByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.
IZResultSetMetaData GetMetaData ()
 Retrieves the number, types and properties of this ResultSet object's columns.
PChar GetPChar (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a PChar in the Delphi programming language.
PChar GetPCharByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a PChar in the Delphi programming language.
TZPostUpdatesMode GetPostUpdates ()
Integer GetRow ()
 Retrieves the current row number.
SmallInt GetShort (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
SmallInt GetShortByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.
IZStatement GetStatement ()
string GetString (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
string GetStringByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
TDateTime GetTime (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
TDateTime GetTimeByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.
TDateTime GetTimestamp (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.
TDateTime GetTimestampByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.
TZResultSetType GetType ()
 Returns the type of this ResultSet object.
TStream GetUnicodeStream (Integer ColumnIndex)
 Gets the value of a column in the current row as a stream of Gets the value of the designated column in the current row of this ResultSet object as as a stream of Unicode characters.
TStream GetUnicodeStreamByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a stream of Unicode characters.
WideString GetUnicodeString (Integer ColumnIndex)
 Gets the value of the designated column in the current row of this ResultSet object as a WideString in the Delphi programming language.
WideString GetUnicodeStringByName (const string ColumnName)
 Gets the value of the designated column in the current row of this ResultSet object as a WideString in the Object Pascal programming language.
TZVariant GetValue (Integer ColumnIndex)
 Returns the value of the designated column in the current row of this ResultSet object as a Variant object.
TZVariant GetValueByName (const string ColumnName)
 Returns the value of the designated column in the current row of this ResultSet object as a Variant object.
EZSQLWarning GetWarnings ()
 Returns the first warning reported by calls on this ResultSet object.
 InsertRow ()
 Inserts the contents of the insert row into this ResultSet objaect and into the database.
Boolean IsAfterLast ()
 Indicates whether the cursor is after the last row in this ResultSet object.
Boolean IsBeforeFirst ()
 Indicates whether the cursor is before the first row in this ResultSet object.
Boolean IsFirst ()
 Indicates whether the cursor is on the first row of this ResultSet object.
Boolean IsLast ()
 Indicates whether the cursor is on the last row of this ResultSet object.
Boolean IsNull (Integer ColumnIndex)
 Indicates if the value of the designated column in the current row of this ResultSet object is Null.
Boolean IsNullByName (const string ColumnName)
 Indicates if the value of the designated column in the current row of this ResultSet object is Null.
Boolean Last ()
 Moves the cursor to the last row in this ResultSet object.
Boolean MoveAbsolute (Integer Row)
 Moves the cursor to the given row number in this ResultSet object.
Boolean MoveRelative (Integer Rows)
 Moves the cursor a relative number of rows, either positive or negative.
 MoveToCurrentRow ()
 Moves the cursor to the remembered cursor position, usually the current row.
 MoveToInsertRow ()
 Moves the cursor to the insert row.
Boolean Next ()
 Moves the cursor down one row from its current position.
Boolean Previous ()
 Moves the cursor to the previous row in this ResultSet object.
 RefreshRow ()
 Refreshes the current row with its most recent value in the database.
Boolean RowDeleted ()
 Indicates whether a row has been deleted.
Boolean RowInserted ()
 Indicates whether the current row has had an insertion.
Boolean RowUpdated ()
 Indicates whether the current row has been updated.
 SetConcurrency (TZResultSetConcurrency Value)
 Set the concurrency mode of this ResultSet object.
 SetFetchDirection (TZFetchDirection Direction)
 Gives a hint as to the direction in which the rows in this ResultSet object will be processed.
 SetFetchSize (Integer Rows)
 Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.
 SetType (TZResultSetType Value)
 Set the type of this ResultSet object.
 TZOracleResultSet (IZOraclePlainDriver PlainDriver, IZStatement Statement, string SQL, POCIStmt StmtHandle, POCIError ErrorHandle)
 Constructs this object, assignes main properties and opens the record set.
 UpdateAsciiStream (Integer ColumnIndex, TStream Value)
 Updates the designated column with an ascii stream value.
 UpdateAsciiStreamByName (const string ColumnName, TStream Value)
 Updates the designated column with an ascii stream value.
 UpdateBigDecimal (Integer ColumnIndex, Extended Value)
 Updates the designated column with a java.math.BigDecimal value.
 UpdateBigDecimalByName (const string ColumnName, Extended Value)
 Updates the designated column with a java.sql.BigDecimal value.
 UpdateBinaryStream (Integer ColumnIndex, TStream Value)
 Updates the designated column with a binary stream value.
 UpdateBinaryStreamByName (const string ColumnName, TStream Value)
 Updates the designated column with a binary stream value.
 UpdateBoolean (Integer ColumnIndex, Boolean Value)
 Updates the designated column with a boolean value.
 UpdateBooleanByName (const string ColumnName, Boolean Value)
 Updates the designated column with a boolean value.
 UpdateByte (Integer ColumnIndex, ShortInt Value)
 Updates the designated column with a byte value.
 UpdateByteByName (const string ColumnName, ShortInt Value)
 Updates the designated column with a byte value.
 UpdateBytes (Integer ColumnIndex, const TByteDynArray Value)
 Updates the designated column with a byte array value.
 UpdateBytesByName (const string ColumnName, const TByteDynArray Value)
 Updates the designated column with a boolean value.
 UpdateDate (Integer ColumnIndex, TDateTime Value)
 Updates the designated column with a java.sql.Date value.
 UpdateDateByName (const string ColumnName, TDateTime Value)
 Updates the designated column with a java.sql.Date value.
 UpdateDouble (Integer ColumnIndex, Double Value)
 Updates the designated column with a double value.
 UpdateDoubleByName (const string ColumnName, Double Value)
 Updates the designated column with a double value.
 UpdateFloat (Integer ColumnIndex, Single Value)
 Updates the designated column with a float value.
 UpdateFloatByName (const string ColumnName, Single Value)
 Updates the designated column with a float value.
 UpdateInt (Integer ColumnIndex, Integer Value)
 Updates the designated column with an int value.
 UpdateIntByName (const string ColumnName, Integer Value)
 Updates the designated column with an int value.
 UpdateLong (Integer ColumnIndex, Int64 Value)
 Updates the designated column with a long value.
 UpdateLongByName (const string ColumnName, Int64 Value)
 Updates the designated column with a long value.
 UpdateNull (Integer ColumnIndex)
 Gives a nullable column a null value.
 UpdateNullByName (const string ColumnName)
 Updates the designated column with a null value.
 UpdatePChar (Integer ColumnIndex, PChar Value)
 Updates the designated column with a String value.
 UpdatePCharByName (const string ColumnName, PChar Value)
 Updates the designated column with a String value.
 UpdateRow ()
 Updates the underlying database with the new contents of the current row of this ResultSet object.
 UpdateShort (Integer ColumnIndex, SmallInt Value)
 Updates the designated column with a short value.
 UpdateShortByName (const string ColumnName, SmallInt Value)
 Updates the designated column with a short value.
 UpdateString (Integer ColumnIndex, const string Value)
 Updates the designated column with a String value.
 UpdateStringByName (const string ColumnName, const string Value)
 Updates the designated column with a String value.
 UpdateTime (Integer ColumnIndex, TDateTime Value)
 Updates the designated column with a java.sql.Time value.
 UpdateTimeByName (const string ColumnName, TDateTime Value)
 Updates the designated column with a java.sql.Time value.
 UpdateTimestamp (Integer ColumnIndex, TDateTime Value)
 Updates the designated column with a java.sql.Timestamp value.
 UpdateTimestampByName (const string ColumnName, TDateTime Value)
 Updates the designated column with a java.sql.Timestamp value.
 UpdateUnicodeStream (Integer ColumnIndex, TStream Value)
 Updates the designated column with a character stream value.
 UpdateUnicodeStreamByName (const string ColumnName, TStream Value)
 Updates the designated column with a character stream value.
 UpdateUnicodeString (Integer ColumnIndex, const WideString Value)
 Updates the designated column with a WideString value.
 UpdateUnicodeStringByName (const string ColumnName, const WideString Value)
 Updates the designated column with a WideString value.
 UpdateValue (Integer ColumnIndex, const TZVariant Value)
 Updates the designated column with a variant value.
 UpdateValueByName (const string ColumnName, const TZVariant Value)
 Updates the designated column with a Variant value.
Boolean WasNull ()
 Reports whether the last column read had a value of SQL NULL.
 ~TZOracleResultSet ()
 Destroys this object and cleanups the memory.

Public Attributes

TObjectList ColumnsInfo

Protected Member Functions

 CheckBlobColumn (Integer ColumnIndex)
 Checks for blob expected column.
 CheckClosed ()
 Checks if result set is open and operation is allowed.
 CheckColumnConvertion (Integer ColumnIndex, TZSQLType ResultType)
 Checks is the column convertion from one type to another type allowed.
TDateTime GetAsDateTimeValue (Integer ColumnIndex, PZSQLVar SQLVarHolder)
 Gets the value of the designated column in the current row of this ResultSet object as a DateTime.
Double GetAsDoubleValue (Integer ColumnIndex, PZSQLVar SQLVarHolder)
 Gets the value of the designated column in the current row of this ResultSet object as a Double.
LongInt GetAsLongIntValue (Integer ColumnIndex, PZSQLVar SQLVarHolder)
 Gets the value of the designated column in the current row of this ResultSet object as a LongInt.
string GetAsStringValue (Integer ColumnIndex, PZSQLVar SQLVarHolder)
 Gets the value of the designated column in the current row of this ResultSet object as a String.
Integer GetColumnIndex (const string ColumnName)
 Maps the given ResultSet column name to its ResultSet column index.
PZSQLVar GetSQLVarHolder (Integer ColumnIndex)
 Gets a holder for SQL output variable.
 Open ()
 Opens this recordset.
 RaiseForwardOnlyException ()
 Raises operation is not allowed in FORWARD ONLY mode exception.
 RaiseReadOnlyException ()
 Raises operation is not allowed in READ ONLY mode exception.
 RaiseUnsupportedException ()
 Raises unsupported operation exception.

Protected Attributes

Boolean Closed
TZFetchDirection FetchDirection
Integer FetchSize
Integer LastRowNo
Boolean LastWasNull
Integer MaxRows
TContainedObject Metadata
TZResultSetConcurrency ResultSetConcurrency
TZResultSetType ResultSetType
Integer RowNo
IZStatement Statement

Private Attributes

POCIError FErrorHandle
PZSQLVars FOutVars
IZOraclePlainDriver FPlainDriver
string FSQL
POCIStmt FStmtHandle


Detailed Description

Implements Oracle ResultSet.

Definition at line 67 of file ZDbcOracleResultSet.pas.


Constructor & Destructor Documentation

TZOracleResultSet::TZOracleResultSet ( IZOraclePlainDriver  PlainDriver,
IZStatement  Statement,
string  SQL,
POCIStmt  StmtHandle,
POCIError  ErrorHandle 
)

Constructs this object, assignes main properties and opens the record set.

Parameters:
PlainDriver a Oracle plain driver.
Statement a related SQL statement object.
SQL a SQL statement.
Handle a Oracle specific query handle.

Definition at line 287 of file ZDbcOracleResultSet.pas.

TZOracleResultSet::~TZOracleResultSet (  ) 

Destroys this object and cleanups the memory.

Definition at line 311 of file ZDbcOracleResultSet.pas.


Member Function Documentation

TZAbstractResultSet::AfterLast (  )  [inherited]

Moves the cursor to the end of this ResultSet object, just after the last row.

This method has no effect if the result set contains no rows.

Reimplemented from IZResultSet.

Reimplemented in TZCachedResultSet.

Definition at line 2374 of file ZDbcResultSet.pas.

TZAbstractResultSet::BeforeFirst (  )  [inherited]

Moves the cursor to the front of this ResultSet object, just before the first row.

This method has no effect if the result set contains no rows.

Reimplemented from IZResultSet.

Definition at line 2361 of file ZDbcResultSet.pas.

TZAbstractResultSet::CancelRowUpdates (  )  [inherited]

Cancels the updates made to the current row in this ResultSet object.

This method may be called after calling an updateXXX method(s) and before calling the method updateRow to roll back the updates made to a row. If no updates have been made or updateRow has already been called, this method has no effect.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3604 of file ZDbcResultSet.pas.

TZAbstractResultSet::CheckBlobColumn ( Integer  ColumnIndex  )  [protected, inherited]

Checks for blob expected column.

Parameters:
ColumnIndex an index of column.

Definition at line 995 of file ZDbcResultSet.pas.

TZAbstractResultSet::CheckClosed (  )  [protected, inherited]

Checks if result set is open and operation is allowed.

Definition at line 947 of file ZDbcResultSet.pas.

TZAbstractResultSet::CheckColumnConvertion ( Integer  ColumnIndex,
TZSQLType  ResultType 
) [protected, inherited]

Checks is the column convertion from one type to another type allowed.

Parameters:
ColumnIndex an index of column.
ResultType a requested data type.

Definition at line 961 of file ZDbcResultSet.pas.

TZAbstractResultSet::ClearWarnings (  )  [inherited]

Clears all warnings reported on this ResultSet object.

After this method is called, the method getWarnings returns null until a new warning is reported for this ResultSet object.

Reimplemented from IZResultSet.

Definition at line 2179 of file ZDbcResultSet.pas.

TZOracleResultSet::Close (  ) 

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Note: A ResultSet object is automatically closed by the Statement object that generated it when that Statement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet object is also automatically closed when it is garbage collected.

Reimplemented from TZAbstractResultSet.

Definition at line 476 of file ZDbcOracleResultSet.pas.

Integer TZAbstractResultSet::CompareRows ( Integer  Row1,
Integer  Row2,
const TIntegerDynArray  ColumnIndices,
const TBooleanDynArray  ColumnDirs 
) [inherited]

Compares fields from two row buffers.

Parameters:
Row1 the first row buffer to compare.
Row2 the second row buffer to compare.
ColumnIndices column indices to compare.
ColumnDirs compare direction for each columns.

Reimplemented from IZResultSet.

Reimplemented in TZAbstractCachedResultSet.

TZAbstractResultSet::DeleteRow (  )  [inherited]

Deletes the current row from this ResultSet object and from the underlying database.

This method cannot be called when the cursor is on the insert row.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3557 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::FindColumn ( const string  ColumnName  )  [inherited]

Maps the given ResultSet column name to its ResultSet column index.

Parameters:
columnName the name of the column
Returns:
the column index of the given column name

Reimplemented from IZResultSet.

Definition at line 2255 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::First (  )  [inherited]

Moves the cursor to the first row in this ResultSet object.

Returns:
true if the cursor is on a valid row; false if there are no rows in the result set

Reimplemented from IZResultSet.

Definition at line 2390 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetAsciiStream ( Integer  ColumnIndex  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large <char>LONGVARCHAR</char> values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Reimplemented in TZMySQLResultSet, and TZSQLiteResultSet.

Definition at line 1510 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetAsciiStreamByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
columnName the SQL name of the column
Returns:
a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.

Reimplemented from IZResultSet.

Definition at line 2039 of file ZDbcResultSet.pas.

TDateTime TZOracleResultSet::GetAsDateTimeValue ( Integer  ColumnIndex,
PZSQLVar  SQLVarHolder 
) [protected]

Gets the value of the designated column in the current row of this ResultSet object as a DateTime.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
SQLVarHolder a reference to SQL variable holder or nil to force retrieving the variable.
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Definition at line 679 of file ZDbcOracleResultSet.pas.

Double TZOracleResultSet::GetAsDoubleValue ( Integer  ColumnIndex,
PZSQLVar  SQLVarHolder 
) [protected]

Gets the value of the designated column in the current row of this ResultSet object as a Double.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
SQLVarHolder a reference to SQL variable holder or nil to force retrieving the variable.
Returns:
the column value; if the value is SQL NULL, the value returned is 0.0

Definition at line 646 of file ZDbcOracleResultSet.pas.

LongInt TZOracleResultSet::GetAsLongIntValue ( Integer  ColumnIndex,
PZSQLVar  SQLVarHolder 
) [protected]

Gets the value of the designated column in the current row of this ResultSet object as a LongInt.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
SQLVarHolder a reference to SQL variable holder or nil to force retrieving the variable.
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Definition at line 613 of file ZDbcOracleResultSet.pas.

string TZOracleResultSet::GetAsStringValue ( Integer  ColumnIndex,
PZSQLVar  SQLVarHolder 
) [protected]

Gets the value of the designated column in the current row of this ResultSet object as a String.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
SQLVarHolder a reference to SQL variable holder or nil to force retrieving the variable.
Returns:
the column value; if the value is SQL NULL, the value returned is null

Definition at line 557 of file ZDbcOracleResultSet.pas.

Extended TZOracleResultSet::GetBigDecimal ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
scale the number of digits to the right of the decimal point
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from TZAbstractResultSet.

Definition at line 939 of file ZDbcOracleResultSet.pas.

Extended TZAbstractResultSet::GetBigDecimalByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1936 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetBinaryStream ( Integer  ColumnIndex  )  [inherited]

Gets the value of a column in the current row as a stream of Gets the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Reimplemented in TZMySQLResultSet, and TZSQLiteResultSet.

Definition at line 1606 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetBinaryStreamByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
columnName the SQL name of the column
Returns:
a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null

Reimplemented from IZResultSet.

Definition at line 2099 of file ZDbcResultSet.pas.

IZBlob TZOracleResultSet::GetBlob ( Integer  ColumnIndex  ) 

Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
Returns:
a Blob object representing the SQL BLOB value in the specified column

Reimplemented from TZAbstractResultSet.

Definition at line 1056 of file ZDbcOracleResultSet.pas.

IZBlob TZAbstractResultSet::GetBlobByName ( const string  ColumnName  )  [inherited]

Returns the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.

Parameters:
colName the name of the column from which to retrieve the value
Returns:
a Blob object representing the SQL BLOB value in the specified column

Reimplemented from IZResultSet.

Definition at line 2117 of file ZDbcResultSet.pas.

Boolean TZOracleResultSet::GetBoolean ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is false

Reimplemented from TZAbstractResultSet.

Definition at line 769 of file ZDbcOracleResultSet.pas.

Boolean TZAbstractResultSet::GetBooleanByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is false

Reimplemented from IZResultSet.

Definition at line 1810 of file ZDbcResultSet.pas.

ShortInt TZOracleResultSet::GetByte ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 800 of file ZDbcOracleResultSet.pas.

ShortInt TZAbstractResultSet::GetByteByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1828 of file ZDbcResultSet.pas.

TByteDynArray TZOracleResultSet::GetBytes ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

The bytes represent the raw values returned by the driver.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from TZAbstractResultSet.

Definition at line 963 of file ZDbcOracleResultSet.pas.

TByteDynArray TZAbstractResultSet::GetBytesByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.

The bytes represent the raw values returned by the driver.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1955 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::GetColumnIndex ( const string  ColumnName  )  [protected, inherited]

Maps the given ResultSet column name to its ResultSet column index.

Parameters:
columnName the name of the column
Returns:
the column index of the given column name

Definition at line 2236 of file ZDbcResultSet.pas.

TZResultSetConcurrency TZAbstractResultSet::GetConcurrency (  )  [inherited]

Returns the concurrency mode of this ResultSet object.

The concurrency used is determined by the Statement object that created the result set.

Returns:
the concurrency type, either CONCUR_READ_ONLY or CONCUR_UPDATABLE

Reimplemented from IZResultSet.

Definition at line 2625 of file ZDbcResultSet.pas.

string TZAbstractResultSet::GetCursorName (  )  [inherited]

Gets the name of the SQL cursor used by this ResultSet object.

In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's select statement should be of the form 'select for update'. If the 'for update' clause is omitted, the positioned updates may fail.

The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a ResultSet object is also the current row of this SQL cursor.

Note: If positioned update is not supported, a SQLException is thrown.

Returns:
the SQL name for this ResultSet object's cursor

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZInterbase6ResultSet.

Definition at line 2208 of file ZDbcResultSet.pas.

TDateTime TZOracleResultSet::GetDate ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from TZAbstractResultSet.

Definition at line 986 of file ZDbcOracleResultSet.pas.

TDateTime TZAbstractResultSet::GetDateByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1973 of file ZDbcResultSet.pas.

Double TZOracleResultSet::GetDouble ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 915 of file ZDbcOracleResultSet.pas.

Double TZAbstractResultSet::GetDoubleByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1918 of file ZDbcResultSet.pas.

TZFetchDirection TZAbstractResultSet::GetFetchDirection (  )  [inherited]

Returns the fetch direction for this ResultSet object.

Returns:
the current fetch direction for this ResultSet object

Reimplemented from IZResultSet.

Definition at line 2540 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::GetFetchSize (  )  [inherited]

Returns the fetch size for this ResultSet object.

Returns:
the current fetch size for this ResultSet object

Reimplemented from IZResultSet.

Definition at line 2571 of file ZDbcResultSet.pas.

Single TZOracleResultSet::GetFloat ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 892 of file ZDbcOracleResultSet.pas.

Single TZAbstractResultSet::GetFloatByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1900 of file ZDbcResultSet.pas.

Integer TZOracleResultSet::GetInt ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 846 of file ZDbcOracleResultSet.pas.

Integer TZAbstractResultSet::GetIntByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1864 of file ZDbcResultSet.pas.

TZLocateUpdatesMode TZAbstractResultSet::GetLocateUpdates (  )  [inherited]

Gets an assigned post locate mode.

Parameters:
the assigned post locate mode.

Reimplemented from IZResultSet.

Definition at line 2637 of file ZDbcResultSet.pas.

Int64 TZOracleResultSet::GetLong ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 869 of file ZDbcOracleResultSet.pas.

Int64 TZAbstractResultSet::GetLongByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1882 of file ZDbcResultSet.pas.

IZResultSetMetaData TZAbstractResultSet::GetMetaData (  )  [inherited]

Retrieves the number, types and properties of this ResultSet object's columns.

Returns:
the description of this ResultSet object's columns

Reimplemented in TZCachedResultSet.

Definition at line 2221 of file ZDbcResultSet.pas.

PChar TZAbstractResultSet::GetPChar ( Integer  ColumnIndex  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a PChar in the Delphi programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Reimplemented in TZAbstractCachedResultSet, TZMySQLResultSet, and TZSQLiteResultSet.

Definition at line 1154 of file ZDbcResultSet.pas.

PChar TZAbstractResultSet::GetPCharByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a PChar in the Delphi programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1755 of file ZDbcResultSet.pas.

TZPostUpdatesMode TZAbstractResultSet::GetPostUpdates (  )  [inherited]

Reimplemented from IZResultSet.

Definition at line 2645 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::GetRow (  )  [inherited]

Retrieves the current row number.

The first row is number 1, the second number 2, and so on.

Returns:
the current row number; 0 if there is no current row

Reimplemented from IZResultSet.

Reimplemented in TZAdoResultSet.

Definition at line 2418 of file ZDbcResultSet.pas.

SmallInt TZOracleResultSet::GetShort ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from TZAbstractResultSet.

Definition at line 823 of file ZDbcOracleResultSet.pas.

SmallInt TZAbstractResultSet::GetShortByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

Reimplemented from IZResultSet.

Definition at line 1846 of file ZDbcResultSet.pas.

PZSQLVar TZOracleResultSet::GetSQLVarHolder ( Integer  ColumnIndex  )  [protected]

Gets a holder for SQL output variable.

Parameters:
ColumnIndex an index of the column to read.
Returns:
an output variable holder or nil if column is empty.

Definition at line 527 of file ZDbcOracleResultSet.pas.

IZStatement TZAbstractResultSet::GetStatement (  )  [inherited]

Reimplemented from IZResultSet.

string TZOracleResultSet::GetString ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from TZAbstractResultSet.

Definition at line 746 of file ZDbcOracleResultSet.pas.

string TZAbstractResultSet::GetStringByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1773 of file ZDbcResultSet.pas.

TDateTime TZOracleResultSet::GetTime ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from TZAbstractResultSet.

Definition at line 1009 of file ZDbcOracleResultSet.pas.

TDateTime TZAbstractResultSet::GetTimeByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1991 of file ZDbcResultSet.pas.

TDateTime TZOracleResultSet::GetTimestamp ( Integer  ColumnIndex  ) 

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null
Exceptions:
SQLException if a database access error occurs

Reimplemented from TZAbstractResultSet.

Definition at line 1033 of file ZDbcOracleResultSet.pas.

TDateTime TZAbstractResultSet::GetTimestampByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 2009 of file ZDbcResultSet.pas.

TZResultSetType TZAbstractResultSet::GetType (  )  [inherited]

Returns the type of this ResultSet object.

The type is determined by the Statement object that created the result set.

Returns:
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, or TYPE_SCROLL_SENSITIVE

Reimplemented from IZResultSet.

Definition at line 2609 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetUnicodeStream ( Integer  ColumnIndex  )  [inherited]

Gets the value of a column in the current row as a stream of Gets the value of the designated column in the current row of this ResultSet object as as a stream of Unicode characters.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving largeLONGVARCHARvalues. The JDBC driver will do any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as specified in the Java virtual machine specification.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
a Java input stream that delivers the database column value as a stream in Java UTF-8 byte format; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Reimplemented in TZMySQLResultSet, and TZSQLiteResultSet.

Definition at line 1560 of file ZDbcResultSet.pas.

TStream TZAbstractResultSet::GetUnicodeStreamByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a stream of Unicode characters.

The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into Unicode. The byte format of the Unicode stream must be Java UTF-8, as defined in the Java virtual machine specification.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
columnName the SQL name of the column
Returns:
a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the value returned is null.

Reimplemented from IZResultSet.

Definition at line 2070 of file ZDbcResultSet.pas.

WideString TZAbstractResultSet::GetUnicodeString ( Integer  ColumnIndex  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a WideString in the Delphi programming language.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Reimplemented in TZAdoResultSet, and TZAbstractCachedResultSet.

Definition at line 1196 of file ZDbcResultSet.pas.

WideString TZAbstractResultSet::GetUnicodeStringByName ( const string  ColumnName  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a WideString in the Object Pascal programming language.

Parameters:
columnName the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is null

Reimplemented from IZResultSet.

Definition at line 1792 of file ZDbcResultSet.pas.

TZVariant TZAbstractResultSet::GetValue ( Integer  ColumnIndex  )  [inherited]

Returns the value of the designated column in the current row of this ResultSet object as a Variant object.

Parameters:
ColumnIndex the first column is 1, the second is 2, ...
Returns:
a Variant object representing the SQL any value in the specified column

Reimplemented from IZResultSet.

Definition at line 1663 of file ZDbcResultSet.pas.

TZVariant TZAbstractResultSet::GetValueByName ( const string  ColumnName  )  [inherited]

Returns the value of the designated column in the current row of this ResultSet object as a Variant object.

Parameters:
colName the name of the column from which to retrieve the value
Returns:
a Blob object representing the SQL Any value in the specified column

Reimplemented from IZResultSet.

Definition at line 2134 of file ZDbcResultSet.pas.

EZSQLWarning TZAbstractResultSet::GetWarnings (  )  [inherited]

Returns the first warning reported by calls on this ResultSet object.

Subsequent warnings on this ResultSet object will be chained to the SQLWarning object that this method returns.

The warning chain is automatically cleared each time a new row is read.

Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by Statement methods (such as reading OUT parameters) will be chained on the Statement object.

Returns:
the first SQLWarning object reported or null

Reimplemented from IZResultSet.

Definition at line 2165 of file ZDbcResultSet.pas.

TZAbstractResultSet::InsertRow (  )  [inherited]

Inserts the contents of the insert row into this ResultSet objaect and into the database.

The cursor must be on the insert row when this method is called.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3531 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::IsAfterLast (  )  [inherited]

Indicates whether the cursor is after the last row in this ResultSet object.

Returns:
true if the cursor is after the last row; false if the cursor is at any other position or the result set contains no rows

Reimplemented from IZResultSet.

Reimplemented in TZCachedResultSet.

Definition at line 2314 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::IsBeforeFirst (  )  [inherited]

Indicates whether the cursor is before the first row in this ResultSet object.

Returns:
true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows

Reimplemented from IZResultSet.

Definition at line 2298 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::IsFirst (  )  [inherited]

Indicates whether the cursor is on the first row of this ResultSet object.

Returns:
true if the cursor is on the first row; false otherwise

Reimplemented from IZResultSet.

Definition at line 2329 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::IsLast (  )  [inherited]

Indicates whether the cursor is on the last row of this ResultSet object.

Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

Returns:
true if the cursor is on the last row; false otherwise

Reimplemented from IZResultSet.

Reimplemented in TZCachedResultSet.

Definition at line 2348 of file ZDbcResultSet.pas.

Boolean TZOracleResultSet::IsNull ( Integer  ColumnIndex  ) 

Indicates if the value of the designated column in the current row of this ResultSet object is Null.

Parameters:
columnIndex the first column is 1, the second is 2, ...
Returns:
if the value is SQL NULL, the value returned is true. false otherwise.

Reimplemented from TZAbstractResultSet.

Definition at line 494 of file ZDbcOracleResultSet.pas.

Boolean TZAbstractResultSet::IsNullByName ( const string  ColumnName  )  [inherited]

Indicates if the value of the designated column in the current row of this ResultSet object is Null.

Parameters:
columnName the SQL name of the column
Returns:
if the value is SQL NULL, the value returned is true. false otherwise.

Reimplemented from IZResultSet.

Definition at line 1737 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::Last (  )  [inherited]

Moves the cursor to the last row in this ResultSet object.

Returns:
true if the cursor is on a valid row; false if there are no rows in the result set

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZCachedResultSet.

Definition at line 2405 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::MoveAbsolute ( Integer  Row  )  [inherited]

Moves the cursor to the given row number in this ResultSet object.

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.

If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method absolute(-1) positions the cursor on the last row; calling the method absolute(-2) moves the cursor to the next-to-last row, and so on.

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.

Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

Returns:
true if the cursor is on the result set; false otherwise

Reimplemented from IZResultSet.

Reimplemented in TZAdoResultSet, TZASAResultSet, TZAbstractCachedResultSet, TZCachedResultSet, TZDBLibResultSet, TZInterbase6ResultSet, TZMySQLResultSet, and TZPostgreSQLResultSet.

Definition at line 2453 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::MoveRelative ( Integer  Rows  )  [inherited]

Moves the cursor a relative number of rows, either positive or negative.

Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.

Note: Calling the method relative(1) is different from calling the method next() because is makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.

Returns:
true if the cursor is on a row; false otherwise

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet.

Definition at line 2480 of file ZDbcResultSet.pas.

TZAbstractResultSet::MoveToCurrentRow (  )  [inherited]

Moves the cursor to the remembered cursor position, usually the current row.

This method has no effect if the cursor is not on the insert row.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3642 of file ZDbcResultSet.pas.

TZAbstractResultSet::MoveToInsertRow (  )  [inherited]

Moves the cursor to the insert row.

The current cursor position is remembered while the cursor is positioned on the insert row.

The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updateXXX methods prior to inserting the row into the result set.

Only the updateXXX, getXXX, and insertRow methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow. An updateXXX method must be called before a getXXX method can be called on a column value.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3629 of file ZDbcResultSet.pas.

Boolean TZOracleResultSet::Next (  ) 

Moves the cursor down one row from its current position.

A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Returns:
true if the new current row is valid; false if there are no more rows

Reimplemented from TZAbstractResultSet.

Definition at line 1116 of file ZDbcOracleResultSet.pas.

TZOracleResultSet::Open (  )  [protected]

Opens this recordset.

Reimplemented from TZAbstractResultSet.

Definition at line 322 of file ZDbcOracleResultSet.pas.

Boolean TZAbstractResultSet::Previous (  )  [inherited]

Moves the cursor to the previous row in this ResultSet object.

Note: Calling the method previous() is not the same as calling the method relative(-1) because it makes sense to callprevious() when there is no current row.

Returns:
true if the cursor is on a valid row; false if it is off the result set

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet.

Definition at line 2500 of file ZDbcResultSet.pas.

TZAbstractResultSet::RaiseForwardOnlyException (  )  [protected, inherited]

Raises operation is not allowed in FORWARD ONLY mode exception.

Definition at line 925 of file ZDbcResultSet.pas.

TZAbstractResultSet::RaiseReadOnlyException (  )  [protected, inherited]

Raises operation is not allowed in READ ONLY mode exception.

Definition at line 936 of file ZDbcResultSet.pas.

TZAbstractResultSet::RaiseUnsupportedException (  )  [protected, inherited]

Raises unsupported operation exception.

Definition at line 914 of file ZDbcResultSet.pas.

TZAbstractResultSet::RefreshRow (  )  [inherited]

Refreshes the current row with its most recent value in the database.

This method cannot be called when the cursor is on the insert row.

The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.

All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow is called after calling an updateXXX method, but before calling the method updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet.

Definition at line 3586 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::RowDeleted (  )  [inherited]

Indicates whether a row has been deleted.

A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not this ResultSet object can detect deletions.

Returns:
true if a row was deleted and deletions are detected; false otherwise

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2697 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::RowInserted (  )  [inherited]

Indicates whether the current row has had an insertion.

The value returned depends on whether or not this ResultSet object can detect visible inserts.

Returns:
true if a row has had an insertion and insertions are detected; false otherwise

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2680 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::RowUpdated (  )  [inherited]

Indicates whether the current row has been updated.

The value returned depends on whether or not the result set can detect updates.

Returns:
true if the row has been visibly updated by the owner or another, and updates are detected

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2664 of file ZDbcResultSet.pas.

TZAbstractResultSet::SetConcurrency ( TZResultSetConcurrency  Value  )  [inherited]

Set the concurrency mode of this ResultSet object.

The concurrency used is determined by the Statement object that created the result set.

Parameters:
the concurrency type, either CONCUR_READ_ONLY or CONCUR_UPDATABLE

Definition at line 1031 of file ZDbcResultSet.pas.

TZAbstractResultSet::SetFetchDirection ( TZFetchDirection  Direction  )  [inherited]

Gives a hint as to the direction in which the rows in this ResultSet object will be processed.

The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.

Reimplemented from IZResultSet.

Definition at line 2556 of file ZDbcResultSet.pas.

TZAbstractResultSet::SetFetchSize ( Integer  Rows  )  [inherited]

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.

If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

Parameters:
rows the number of rows to fetch

Reimplemented from IZResultSet.

Definition at line 2591 of file ZDbcResultSet.pas.

TZAbstractResultSet::SetType ( TZResultSetType  Value  )  [inherited]

Set the type of this ResultSet object.

The type is determined by the Statement object that created the result set.

Parameters:
<code>TYPE_FORWARD_ONLY</code>,<code>TYPE_SCROLL_INSENSITIVE</code>,or TYPE_SCROLL_SENSITIVE

Definition at line 1049 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateAsciiStream ( Integer  ColumnIndex,
TStream  Value 
) [inherited]

Updates the designated column with an ascii stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3037 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateAsciiStreamByName ( const string  ColumnName,
TStream  Value 
) [inherited]

Updates the designated column with an ascii stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3456 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBigDecimal ( Integer  ColumnIndex,
Extended  Value 
) [inherited]

Updates the designated column with a java.math.BigDecimal value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2876 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBigDecimalByName ( const string  ColumnName,
Extended  Value 
) [inherited]

Updates the designated column with a java.sql.BigDecimal value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3286 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBinaryStream ( Integer  ColumnIndex,
TStream  Value 
) [inherited]

Updates the designated column with a binary stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value
length the length of the stream

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3058 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBinaryStreamByName ( const string  ColumnName,
TStream  Value 
) [inherited]

Updates the designated column with a binary stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3476 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBoolean ( Integer  ColumnIndex,
Boolean  Value 
) [inherited]

Updates the designated column with a boolean value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2734 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBooleanByName ( const string  ColumnName,
Boolean  Value 
) [inherited]

Updates the designated column with a boolean value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3145 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateByte ( Integer  ColumnIndex,
ShortInt  Value 
) [inherited]

Updates the designated column with a byte value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2755 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateByteByName ( const string  ColumnName,
ShortInt  Value 
) [inherited]

Updates the designated column with a byte value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3165 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBytes ( Integer  ColumnIndex,
const TByteDynArray  Value 
) [inherited]

Updates the designated column with a byte array value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2956 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateBytesByName ( const string  ColumnName,
const TByteDynArray  Value 
) [inherited]

Updates the designated column with a boolean value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

JDBC 2.0

Updates a column with a byte array value.

The updateXXX methods are used to update column values in the current row, or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3375 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateDate ( Integer  ColumnIndex,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Date value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2976 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateDateByName ( const string  ColumnName,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Date value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3395 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateDouble ( Integer  ColumnIndex,
Double  Value 
) [inherited]

Updates the designated column with a double value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2855 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateDoubleByName ( const string  ColumnName,
Double  Value 
) [inherited]

Updates the designated column with a double value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3265 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateFloat ( Integer  ColumnIndex,
Single  Value 
) [inherited]

Updates the designated column with a float value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2835 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateFloatByName ( const string  ColumnName,
Single  Value 
) [inherited]

Updates the designated column with a float value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3245 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateInt ( Integer  ColumnIndex,
Integer  Value 
) [inherited]

Updates the designated column with an int value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2795 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateIntByName ( const string  ColumnName,
Integer  Value 
) [inherited]

Updates the designated column with an int value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3205 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateLong ( Integer  ColumnIndex,
Int64  Value 
) [inherited]

Updates the designated column with a long value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2815 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateLongByName ( const string  ColumnName,
Int64  Value 
) [inherited]

Updates the designated column with a long value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3225 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateNull ( Integer  ColumnIndex  )  [inherited]

Gives a nullable column a null value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2715 of file ZDbcResultSet.pas.

References Create().

TZAbstractResultSet::UpdateNullByName ( const string  ColumnName  )  [inherited]

Updates the designated column with a null value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column

Reimplemented from IZResultSet.

Definition at line 3126 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdatePChar ( Integer  ColumnIndex,
PChar  Value 
) [inherited]

Updates the designated column with a String value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2896 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdatePCharByName ( const string  ColumnName,
PChar  Value 
) [inherited]

Updates the designated column with a String value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3306 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateRow (  )  [inherited]

Updates the underlying database with the new contents of the current row of this ResultSet object.

This method cannot be called when the cursor is on the insert row.

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3544 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateShort ( Integer  ColumnIndex,
SmallInt  Value 
) [inherited]

Updates the designated column with a short value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2775 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateShortByName ( const string  ColumnName,
SmallInt  Value 
) [inherited]

Updates the designated column with a short value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3185 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateString ( Integer  ColumnIndex,
const string  Value 
) [inherited]

Updates the designated column with a String value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2916 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateStringByName ( const string  ColumnName,
const string  Value 
) [inherited]

Updates the designated column with a String value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3326 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateTime ( Integer  ColumnIndex,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Time value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2996 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateTimeByName ( const string  ColumnName,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Time value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3415 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateTimestamp ( Integer  ColumnIndex,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Timestamp value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3017 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateTimestampByName ( const string  ColumnName,
TDateTime  Value 
) [inherited]

Updates the designated column with a java.sql.Timestamp value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3436 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateUnicodeStream ( Integer  ColumnIndex,
TStream  Value 
) [inherited]

Updates the designated column with a character stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 3078 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateUnicodeStreamByName ( const string  ColumnName,
TStream  Value 
) [inherited]

Updates the designated column with a character stream value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3496 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateUnicodeString ( Integer  ColumnIndex,
const WideString  Value 
) [inherited]

Updates the designated column with a WideString value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet, and TZAbstractCachedResultSet.

Definition at line 2936 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateUnicodeStringByName ( const string  ColumnName,
const WideString  Value 
) [inherited]

Updates the designated column with a WideString value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3346 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateValue ( Integer  ColumnIndex,
const TZVariant  Value 
) [inherited]

Updates the designated column with a variant value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnIndex the first column is 1, the second is 2, ...
x the new column value

Reimplemented from IZResultSet.

Reimplemented in TZASAResultSet.

Definition at line 3098 of file ZDbcResultSet.pas.

TZAbstractResultSet::UpdateValueByName ( const string  ColumnName,
const TZVariant  Value 
) [inherited]

Updates the designated column with a Variant value.

The updateXXX methods are used to update column values in the current row or the insert row. The updateXXX methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:
columnName the name of the column
x the new column value

Reimplemented from IZResultSet.

Definition at line 3516 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::WasNull (  )  [inherited]

Reports whether the last column read had a value of SQL NULL.

Note that you must first call one of the getXXX methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.

Returns:
true if the last column value read was SQL NULL and false otherwise

Reimplemented from IZResultSet.

Definition at line 1116 of file ZDbcResultSet.pas.


Member Data Documentation

Boolean TZAbstractResultSet::Closed [protected, inherited]

See also:
FClosed For reading

FClosed For writing

Definition at line 160 of file ZDbcResultSet.pas.

TObjectList TZAbstractResultSet::ColumnsInfo [inherited]

See also:
FColumnsInfo For reading

FColumnsInfo For writing

Definition at line 742 of file ZDbcResultSet.pas.

Definition at line 76 of file ZDbcOracleResultSet.pas.

See also:
FFetchDirection For reading

FFetchDirection For writing

Definition at line 164 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::FetchSize [protected, inherited]

See also:
FFetchSize For reading

FFetchSize For writing

Definition at line 167 of file ZDbcResultSet.pas.

Definition at line 80 of file ZDbcOracleResultSet.pas.

Definition at line 78 of file ZDbcOracleResultSet.pas.

string TZOracleResultSet::FSQL [private]

Definition at line 72 of file ZDbcOracleResultSet.pas.

Definition at line 74 of file ZDbcOracleResultSet.pas.

Integer TZAbstractResultSet::LastRowNo [protected, inherited]

See also:
FLastRowNo For reading

FLastRowNo For writing

Definition at line 154 of file ZDbcResultSet.pas.

Boolean TZAbstractResultSet::LastWasNull [protected, inherited]

Definition at line 118 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::MaxRows [protected, inherited]

See also:
FMaxRows For reading

FMaxRows For writing

Definition at line 157 of file ZDbcResultSet.pas.

TContainedObject TZAbstractResultSet::Metadata [protected, inherited]

See also:
FMetadata For reading

FMetadata For writing

Definition at line 181 of file ZDbcResultSet.pas.

See also:
FResultSetConcurrency For reading

FResultSetConcurrency For writing

Definition at line 175 of file ZDbcResultSet.pas.

See also:
FResultSetType For reading

FResultSetType For writing

Definition at line 171 of file ZDbcResultSet.pas.

Integer TZAbstractResultSet::RowNo [protected, inherited]

See also:
FRowNo For reading

FRowNo For writing

Definition at line 151 of file ZDbcResultSet.pas.

See also:
FStatement For reading

Definition at line 178 of file ZDbcResultSet.pas.


The documentation for this class was generated from the following file:

Generated on Wed Dec 30 08:42:55 2009 for zeoslib by  doxygen 1.5.7.1