TZVirtualResultSet Class Reference

Implements Virtual ResultSet. More...

Inheritance diagram for TZVirtualResultSet:

TZAbstractCachedResultSet IZVirtualResultSet TZAbstractResultSet IZCachedResultSet 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.
 CancelUpdates ()
 Cancels updates for all rows.
 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.
IZCachedResolver GetNativeResolver ()
 Gets a Native cached updates resolver object.
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 ()
IZCachedResolver GetResolver ()
 Gets a cached updates resolver object.
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 Java 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 object 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 IsCachedUpdates ()
 Checks is the cached updates mode turned on.
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 IsPendingUpdates ()
 Checks is cached updates pending.
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.
 MoveToInitialRow ()
 Moves to the current row with initial column values.
 MoveToInsertRow ()
 Moves the cursor to the insert row.
Boolean Next ()
 Moves the cursor down one row from its current position.
 PostUpdates ()
 Posts all saved updates to the server.
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.
 RevertRecord ()
 Cancels updates for the current row.
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.
 SetCachedUpdates (Boolean Value)
 Switched the cached updates mode.
 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.
 SetResolver (IZCachedResolver Resolver)
 Sets a new cached updates resolver object.
 SetType (TZResultSetType Value)
 Set the type of this ResultSet object.
 TZVirtualResultSet (TObjectList ColumnsInfo, const string SQL)
 Creates this object and assignes the main properties.
 TZVirtualResultSet (const string SQL, IZStatement Statement)
 Creates this object and assignes the main properties.
 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.
 ~TZVirtualResultSet ()
 Destroys this object and cleanups the memory.

Public Attributes

TObjectList ColumnsInfo

Protected Member Functions

PZRowBuffer AppendRow (PZRowBuffer Row)
 Appends a row to the list of rows if such row is not exist.
 CalculateRowDefaults (TZRowAccessor RowAccessor)
 Calculates column default values.
 CheckAvailable ()
 Checks for availability of the cached buffer.
 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.
 CheckUpdatable ()
 Checks is the cached buffer updatable.
Integer GetColumnIndex (const string ColumnName)
 Maps the given ResultSet column name to its ResultSet column index.
Integer GetNextRowIndex ()
 Generates the next row index value.
Integer LocateRow (TList RowsList, Integer RowIndex)
 Finds a row with specified index among list of rows.
 Open ()
 Opens this recordset.
 PostRowUpdates (TZRowAccessor OldRowAccessor, TZRowAccessor NewRowAccessor)
 Post changes to database server.
 PrepareRowForUpdates ()
 Prepares the current selected row for updates.
 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 CachedUpdates
Boolean Closed
TList CurrentRowsList
TZFetchDirection FetchDirection
Integer FetchSize
TList InitialRowsList
PZRowBuffer InsertedRow
Integer LastRowNo
Boolean LastWasNull
Integer MaxRows
TContainedObject Metadata
IZCachedResolver NativeResolver
TZRowAccessor NewRowAccessor
Integer NextRowIndex
TZRowAccessor OldRowAccessor
IZCachedResolver Resolver
TZResultSetConcurrency ResultSetConcurrency
TZResultSetType ResultSetType
TZRowAccessor RowAccessor
Integer RowNo
TList RowsList
PZRowBuffer SelectedRow
IZStatement Statement
PZRowBuffer UpdatedRow


Detailed Description

Implements Virtual ResultSet.

Definition at line 121 of file ZDbcMetadata.pas.


Constructor & Destructor Documentation

TZVirtualResultSet::TZVirtualResultSet ( const string  SQL,
IZStatement  Statement 
)

Creates this object and assignes the main properties.

Parameters:
Statement an SQL statement object.
SQL an SQL query string.

Definition at line 5527 of file ZDbcMetadata.pas.

TZVirtualResultSet::TZVirtualResultSet ( TObjectList  ColumnsInfo,
const string  SQL 
)

Creates this object and assignes the main properties.

Parameters:
ColumnsInfo a columns info for cached rows.
SQL an SQL query string.

Definition at line 5542 of file ZDbcMetadata.pas.

TZVirtualResultSet::~TZVirtualResultSet (  ) 

Destroys this object and cleanups the memory.

Definition at line 5555 of file ZDbcMetadata.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.

PZRowBuffer TZAbstractCachedResultSet::AppendRow ( PZRowBuffer  Row  )  [protected, inherited]

Appends a row to the list of rows if such row is not exist.

Parameters:
Row a row buffer.
Returns:
an appended row buffer.

Definition at line 739 of file ZDbcCachedResultSet.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.

TZVirtualResultSet::CalculateRowDefaults ( TZRowAccessor  RowAccessor  )  [protected]

Calculates column default values.

Parameters:
RowAccessor a row accessor which contains new column values.

Reimplemented from TZAbstractCachedResultSet.

Definition at line 5567 of file ZDbcMetadata.pas.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2281 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::CancelUpdates (  )  [inherited]

Cancels updates for all rows.

Reimplemented from IZCachedResultSet.

Definition at line 952 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::CheckAvailable (  )  [protected, inherited]

Checks for availability of the cached buffer.

Definition at line 671 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::CheckUpdatable (  )  [protected, inherited]

Checks is the cached buffer updatable.

Definition at line 684 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::Close (  )  [inherited]

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.

Reimplemented in TZCachedResultSet.

Definition at line 1060 of file ZDbcCachedResultSet.pas.

Integer TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2338 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2235 of file ZDbcCachedResultSet.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.

Extended TZAbstractCachedResultSet::GetBigDecimal ( Integer  ColumnIndex  )  [inherited]

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 1367 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetBlob ( Integer  ColumnIndex  )  [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:
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 1484 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetBoolean ( Integer  ColumnIndex  )  [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:
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 1205 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetByte ( Integer  ColumnIndex  )  [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:
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 1228 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetBytes ( Integer  ColumnIndex  )  [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:
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 1391 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetDate ( Integer  ColumnIndex  )  [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:
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 1414 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetDouble ( Integer  ColumnIndex  )  [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:
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 1343 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetFloat ( Integer  ColumnIndex  )  [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:
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 1320 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetInt ( Integer  ColumnIndex  )  [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:
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 1274 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetLong ( Integer  ColumnIndex  )  [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:
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 1297 of file ZDbcCachedResultSet.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.

IZCachedResolver TZAbstractCachedResultSet::GetNativeResolver (  )  [inherited]

Gets a Native cached updates resolver object.

Returns:
a Native cached updates resolver object.

Reimplemented from IZCachedResultSet.

Definition at line 842 of file ZDbcCachedResultSet.pas.

Integer TZAbstractCachedResultSet::GetNextRowIndex (  )  [protected, inherited]

Generates the next row index value.

Returns:
the new generated row index.

Definition at line 698 of file ZDbcCachedResultSet.pas.

PChar TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1136 of file ZDbcCachedResultSet.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.

IZCachedResolver TZAbstractCachedResultSet::GetResolver (  )  [inherited]

Gets a cached updates resolver object.

Returns:
a cached updates resolver object.

Reimplemented from IZCachedResultSet.

Definition at line 813 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetShort ( Integer  ColumnIndex  )  [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:
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 1251 of file ZDbcCachedResultSet.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.

IZStatement TZAbstractResultSet::GetStatement (  )  [inherited]

Reimplemented from IZResultSet.

string TZAbstractCachedResultSet::GetString ( Integer  ColumnIndex  )  [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:
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 1159 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetTime ( Integer  ColumnIndex  )  [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:
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 1437 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetTimestamp ( Integer  ColumnIndex  )  [inherited]

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 1461 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::GetUnicodeString ( Integer  ColumnIndex  )  [inherited]

Gets the value of the designated column in the current row of this ResultSet object as a Widestring 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 1182 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::InsertRow (  )  [inherited]

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

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

Reimplemented from TZAbstractResultSet.

Definition at line 2138 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::IsCachedUpdates (  )  [inherited]

Checks is the cached updates mode turned on.

Returns:
True if the cached updates mode turned on.

Reimplemented from IZCachedResultSet.

Definition at line 855 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::IsNull ( Integer  ColumnIndex  )  [inherited]

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 1113 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::IsPendingUpdates (  )  [inherited]

Checks is cached updates pending.

Returns:
True if the cached updates pending.

Reimplemented from IZCachedResultSet.

Definition at line 883 of file ZDbcCachedResultSet.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.

Integer TZAbstractCachedResultSet::LocateRow ( TList  RowsList,
Integer  RowIndex 
) [protected, inherited]

Finds a row with specified index among list of rows.

Parameters:
RowsList a list of rows.
Index a row index.
Returns:
a found row buffer of null otherwise.

Definition at line 713 of file ZDbcCachedResultSet.pas.

Boolean TZAbstractCachedResultSet::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 TZAbstractResultSet.

Reimplemented in TZCachedResultSet.

Definition at line 2029 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2320 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::MoveToInitialRow (  )  [inherited]

Moves to the current row with initial column values.

Reimplemented from IZCachedResultSet.

Definition at line 894 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2306 of file ZDbcCachedResultSet.pas.

Boolean TZAbstractResultSet::Next (  )  [inherited]

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 IZResultSet.

Reimplemented in TZAdoResultSet, TZASAResultSet, TZDBLibResultSet, TZInterbase6ResultSet, TZMySQLResultSet, TZOracleResultSet, and TZSQLiteResultSet.

Definition at line 2523 of file ZDbcResultSet.pas.

References P.

TZAbstractCachedResultSet::Open (  )  [protected, inherited]

Opens this recordset.

Reimplemented from TZAbstractResultSet.

Reimplemented in TZCachedResultSet.

Definition at line 1019 of file ZDbcCachedResultSet.pas.

TZVirtualResultSet::PostRowUpdates ( TZRowAccessor  OldRowAccessor,
TZRowAccessor  NewRowAccessor 
) [protected]

Post changes to database server.

Parameters:
OldRowAccessor a row accessor which contains old column values.
NewRowAccessor a row accessor which contains new or updated column values.

Reimplemented from TZAbstractCachedResultSet.

Definition at line 5581 of file ZDbcMetadata.pas.

TZAbstractCachedResultSet::PostUpdates (  )  [inherited]

Posts all saved updates to the server.

Reimplemented from IZCachedResultSet.

Definition at line 918 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::PrepareRowForUpdates (  )  [protected, inherited]

Prepares the current selected row for updates.

Definition at line 756 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::RevertRecord (  )  [inherited]

Cancels updates for the current row.

Reimplemented from IZCachedResultSet.

Definition at line 985 of file ZDbcCachedResultSet.pas.

Boolean TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2115 of file ZDbcCachedResultSet.pas.

Boolean TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2088 of file ZDbcCachedResultSet.pas.

Boolean TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2062 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::SetCachedUpdates ( Boolean  Value  )  [inherited]

Switched the cached updates mode.

Parameters:
Value boolean flag which turns on/off the cached updates mode.

Reimplemented from IZCachedResultSet.

Definition at line 867 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::SetResolver ( IZCachedResolver  Resolver  )  [inherited]

Sets a new cached updates resolver object.

Parameters:
Resolver a cached updates resolver object.

Reimplemented from IZCachedResultSet.

Definition at line 825 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1929 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1720 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1956 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1537 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1563 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1824 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1850 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1693 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1667 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1615 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1641 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1512 of file ZDbcCachedResultSet.pas.

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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1746 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 2188 of file ZDbcCachedResultSet.pas.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1589 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1772 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1876 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1903 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1982 of file ZDbcCachedResultSet.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.

TZAbstractCachedResultSet::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 TZAbstractResultSet.

Definition at line 1798 of file ZDbcCachedResultSet.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 TZAbstractCachedResultSet::CachedUpdates [protected, inherited]

See also:
FCachedUpdates For reading

FCachedUpdates For writing

Definition at line 226 of file ZDbcCachedResultSet.pas.

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.

TList TZAbstractCachedResultSet::CurrentRowsList [protected, inherited]

See also:
FCurrentRowsList For reading

FCurrentRowsList For writing

Definition at line 237 of file ZDbcCachedResultSet.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.

TList TZAbstractCachedResultSet::InitialRowsList [protected, inherited]

See also:
FInitialRowsList For reading

FInitialRowsList For writing

Definition at line 233 of file ZDbcCachedResultSet.pas.

See also:
FInsertedRow For reading

FInsertedRow For writing

Definition at line 246 of file ZDbcCachedResultSet.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:
FNativeResolver For reading

Definition at line 267 of file ZDbcCachedResultSet.pas.

See also:
FNewRowAccessor For reading

FNewRowAccessor For writing

Definition at line 257 of file ZDbcCachedResultSet.pas.

Integer TZAbstractCachedResultSet::NextRowIndex [protected, inherited]

See also:
FNextRowIndex For reading

FNextRowIndex For writing

Definition at line 260 of file ZDbcCachedResultSet.pas.

See also:
FOldRowAccessor For reading

FOldRowAccessor For writing

Definition at line 253 of file ZDbcCachedResultSet.pas.

See also:
FResolver For reading

FResolver For writing

Definition at line 263 of file ZDbcCachedResultSet.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.

See also:
FRowAccessor For reading

FRowAccessor For writing

Definition at line 249 of file ZDbcCachedResultSet.pas.

Integer TZAbstractResultSet::RowNo [protected, inherited]

See also:
FRowNo For reading

FRowNo For writing

Definition at line 151 of file ZDbcResultSet.pas.

TList TZAbstractCachedResultSet::RowsList [protected, inherited]

See also:
FRowsList For reading

FRowsList For writing

Definition at line 229 of file ZDbcCachedResultSet.pas.

See also:
FSelectedRow For reading

FSelectedRow For writing

Definition at line 240 of file ZDbcCachedResultSet.pas.

See also:
FStatement For reading

Definition at line 178 of file ZDbcResultSet.pas.

See also:
FUpdatedRow For reading

FUpdatedRow For writing

Definition at line 243 of file ZDbcCachedResultSet.pas.


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

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