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 byte s. | |
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. | |
TZAbstractCachedResultSet (TObjectList ColumnsInfo, string SQL) | |
Creates this object and assignes the main properties. | |
TZAbstractCachedResultSet (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 . | |
~TZAbstractCachedResultSet () | |
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 |
Private Member Functions | |
IZResultSetMetadata | GetMetadata () |
Private Attributes | |
Boolean | FCachedUpdates |
TList | FCurrentRowsList |
TList | FInitialRowsList |
PZRowBuffer | FInsertedRow |
IZCachedResolver | FNativeResolver |
TZRowAccessor | FNewRowAccessor |
Integer | FNextRowIndex |
TZRowAccessor | FOldRowAccessor |
IZCachedResolver | FResolver |
TZRowAccessor | FRowAccessor |
TList | FRowsList |
PZRowBuffer | FSelectedRow |
PZRowBuffer | FUpdatedRow |
Definition at line 156 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::TZAbstractCachedResultSet | ( | string | SQL, | |
IZStatement | Statement | |||
) |
Creates this object and assignes the main properties.
Statement | an SQL statement object. | |
SQL | an SQL query. |
Definition at line 623 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::TZAbstractCachedResultSet | ( | TObjectList | ColumnsInfo, | |
string | SQL | |||
) |
Creates this object and assignes the main properties.
SQL | an SQL query. | |
ColumnsInfo | a columns info for cached rows. |
Definition at line 639 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::~TZAbstractCachedResultSet | ( | ) |
Destroys this object and cleanups the memory.
Definition at line 656 of file ZDbcCachedResultSet.pas.
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] |
Appends a row to the list of rows if such row is not exist.
Row | a 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.
TZAbstractCachedResultSet::CalculateRowDefaults | ( | TZRowAccessor | RowAccessor | ) | [protected] |
Calculates column default values.
RowAccessor | a row accessor which contains new column values. |
Reimplemented in TZVirtualResultSet.
Definition at line 771 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::CancelRowUpdates | ( | ) |
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 | ( | ) |
Cancels updates for all rows.
Reimplemented from IZCachedResultSet.
Definition at line 952 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::CheckAvailable | ( | ) | [protected] |
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.
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.
ColumnIndex | an index of column. | |
ResultType | a requested data type. |
Definition at line 961 of file ZDbcResultSet.pas.
TZAbstractCachedResultSet::CheckUpdatable | ( | ) | [protected] |
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 | ( | ) |
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 | |||
) |
Compares fields from two row buffers.
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 | ( | ) |
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.
columnName | the name of the column |
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.
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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
. Reimplemented from IZResultSet.
Definition at line 2039 of file ZDbcResultSet.pas.
Extended TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... | |
scale | the number of digits to the right of the decimal point |
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.
columnName | the SQL name of the column |
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.
columnIndex | the first column is 1, the second is 2, ... |
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 byte
s.
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.
columnName | the SQL name of the column |
NULL
, the result is null
Reimplemented from IZResultSet.
Definition at line 2099 of file ZDbcResultSet.pas.
IZBlob TZAbstractCachedResultSet::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.
ColumnIndex | the first column is 1, the second is 2, ... |
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.
colName | the name of the column from which to retrieve the value |
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 | ) |
Gets the value of the designated column in the current row of this ResultSet
object as a boolean
in the Java programming language.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is false
Reimplemented from IZResultSet.
Definition at line 1810 of file ZDbcResultSet.pas.
ShortInt TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is 0
Reimplemented from IZResultSet.
Definition at line 1828 of file ZDbcResultSet.pas.
TByteDynArray TZAbstractCachedResultSet::GetBytes | ( | Integer | ColumnIndex | ) |
Gets the value of the designated column in the current row of this ResultSet
object as a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
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.
columnName | the name of the column |
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.
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.
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 | ) |
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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
Reimplemented from IZResultSet.
Definition at line 1973 of file ZDbcResultSet.pas.
Double TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
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.
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.
ResultSet
object Reimplemented from IZResultSet.
Definition at line 2571 of file ZDbcResultSet.pas.
Single TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is 0
Reimplemented from IZResultSet.
Definition at line 1900 of file ZDbcResultSet.pas.
Integer TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
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.
the | assigned post locate mode. |
Reimplemented from IZResultSet.
Definition at line 2637 of file ZDbcResultSet.pas.
Int64 TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is 0
Reimplemented from IZResultSet.
Definition at line 1882 of file ZDbcResultSet.pas.
IZResultSetMetadata IZResultSet::GetMetadata | ( | ) | [inherited] |
IZResultSetMetaData TZAbstractResultSet::GetMetaData | ( | ) | [inherited] |
Retrieves the number, types and properties of this ResultSet
object's columns.
ResultSet
object's columns Reimplemented in TZCachedResultSet.
Definition at line 2221 of file ZDbcResultSet.pas.
IZCachedResolver TZAbstractCachedResultSet::GetNativeResolver | ( | ) |
Gets a Native cached updates resolver object.
Reimplemented from IZCachedResultSet.
Definition at line 842 of file ZDbcCachedResultSet.pas.
Integer TZAbstractCachedResultSet::GetNextRowIndex | ( | ) | [protected] |
Generates the next row index value.
Definition at line 698 of file ZDbcCachedResultSet.pas.
PChar TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
Reimplemented from IZResultSet.
Definition at line 1755 of file ZDbcResultSet.pas.
TZPostUpdatesMode TZAbstractResultSet::GetPostUpdates | ( | ) | [inherited] |
IZCachedResolver TZAbstractCachedResultSet::GetResolver | ( | ) |
Gets 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.
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 | ) |
Gets the value of the designated column in the current row of this ResultSet
object as a short
in the Java programming language.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
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 | ) |
Gets the value of the designated column in the current row of this ResultSet
object as a String
in the Java programming language.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
Reimplemented from IZResultSet.
Definition at line 1773 of file ZDbcResultSet.pas.
TDateTime TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
Reimplemented from IZResultSet.
Definition at line 1991 of file ZDbcResultSet.pas.
TDateTime TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
NULL
, the value returned is null
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.
columnName | the SQL name of the column |
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.
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 largeLONGVARCHAR
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 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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is null
. Reimplemented from IZResultSet.
Definition at line 2070 of file ZDbcResultSet.pas.
Widestring TZAbstractCachedResultSet::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.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
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.
ColumnIndex | the first column is 1, the second is 2, ... |
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.
colName | the name of the column from which to retrieve the value |
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.
SQLWarning
object reported or null
Reimplemented from IZResultSet.
Definition at line 2165 of file ZDbcResultSet.pas.
TZAbstractCachedResultSet::InsertRow | ( | ) |
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.
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.
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 | ( | ) |
Checks is the cached updates mode turned on.
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.
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.
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 | ) |
Indicates if the value of the designated column in the current row of this ResultSet
object is Null.
columnIndex | the first column is 1, the second is 2, ... |
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.
columnName | the SQL name of the column |
NULL
, the value returned is true
. false
otherwise. Reimplemented from IZResultSet.
Definition at line 1737 of file ZDbcResultSet.pas.
Boolean TZAbstractCachedResultSet::IsPendingUpdates | ( | ) |
Checks is cached updates pending.
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.
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] |
Finds a row with specified index among list of rows.
RowsList | a list of rows. | |
Index | a row index. |
null
otherwise. Definition at line 713 of file ZDbcCachedResultSet.pas.
Boolean TZAbstractCachedResultSet::MoveAbsolute | ( | Integer | Row | ) |
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()
.
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.
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 | ( | ) |
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 | ( | ) |
Moves to the current row with initial column values.
Reimplemented from IZCachedResultSet.
Definition at line 894 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::MoveToInsertRow | ( | ) |
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.
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] |
Opens this recordset.
Reimplemented from TZAbstractResultSet.
Reimplemented in TZCachedResultSet.
Definition at line 1019 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::PostRowUpdates | ( | TZRowAccessor | OldRowAccessor, | |
TZRowAccessor | NewRowAccessor | |||
) | [protected] |
Post changes to database server.
OldRowAccessor | a row accessor which contains old column values. | |
NewRowAccessor | a row accessor which contains new or updated column values. |
Reimplemented in TZVirtualResultSet.
Definition at line 792 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::PostUpdates | ( | ) |
Posts all saved updates to the server.
Reimplemented from IZCachedResultSet.
Definition at line 918 of file ZDbcCachedResultSet.pas.
TZAbstractCachedResultSet::PrepareRowForUpdates | ( | ) | [protected] |
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.
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] |
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 | ( | ) |
Cancels updates for the current row.
Reimplemented from IZCachedResultSet.
Definition at line 985 of file ZDbcCachedResultSet.pas.
Boolean TZAbstractCachedResultSet::RowDeleted | ( | ) |
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.
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 | ( | ) |
Indicates whether the current row has had an insertion.
The value returned depends on whether or not this ResultSet
object can detect visible inserts.
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 | ( | ) |
Indicates whether the current row has been updated.
The value returned depends on whether or not the result set can detect updates.
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 | ) |
Switched the cached updates mode.
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.
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.
rows | the number of rows to fetch |
Reimplemented from IZResultSet.
Definition at line 2591 of file ZDbcResultSet.pas.
TZAbstractCachedResultSet::SetResolver | ( | IZCachedResolver | Resolver | ) |
Sets a new cached updates resolver object.
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.
<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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | ) |
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.
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.
columnName | the name of the column |
Reimplemented from IZResultSet.
Definition at line 3126 of file ZDbcResultSet.pas.
TZAbstractCachedResultSet::UpdatePChar | ( | Integer | ColumnIndex, | |
PChar | Value | |||
) |
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.
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.
columnName | the name of the column | |
x | the new column value |
Reimplemented from IZResultSet.
Definition at line 3306 of file ZDbcResultSet.pas.
TZAbstractCachedResultSet::UpdateRow | ( | ) |
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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 | |||
) |
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.
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.
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.
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.
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
.
true
if the last column value read was SQL NULL
and false
otherwise Reimplemented from IZResultSet.
Definition at line 1116 of file ZDbcResultSet.pas.
Boolean TZAbstractCachedResultSet::CachedUpdates [protected] |
FCachedUpdates For writing
Definition at line 226 of file ZDbcCachedResultSet.pas.
Boolean TZAbstractResultSet::Closed [protected, inherited] |
TObjectList TZAbstractResultSet::ColumnsInfo [inherited] |
FColumnsInfo For writing
Definition at line 742 of file ZDbcResultSet.pas.
TList TZAbstractCachedResultSet::CurrentRowsList [protected] |
FCurrentRowsList For writing
Definition at line 237 of file ZDbcCachedResultSet.pas.
Boolean TZAbstractCachedResultSet::FCachedUpdates [private] |
Definition at line 161 of file ZDbcCachedResultSet.pas.
TList TZAbstractCachedResultSet::FCurrentRowsList [private] |
Definition at line 167 of file ZDbcCachedResultSet.pas.
TZFetchDirection TZAbstractResultSet::FetchDirection [protected, inherited] |
FFetchDirection For writing
Definition at line 164 of file ZDbcResultSet.pas.
Integer TZAbstractResultSet::FetchSize [protected, inherited] |
FFetchSize For writing
Definition at line 167 of file ZDbcResultSet.pas.
TList TZAbstractCachedResultSet::FInitialRowsList [private] |
Definition at line 165 of file ZDbcCachedResultSet.pas.
Definition at line 173 of file ZDbcCachedResultSet.pas.
Definition at line 186 of file ZDbcCachedResultSet.pas.
Definition at line 177 of file ZDbcCachedResultSet.pas.
Integer TZAbstractCachedResultSet::FNextRowIndex [private] |
Definition at line 181 of file ZDbcCachedResultSet.pas.
Definition at line 179 of file ZDbcCachedResultSet.pas.
Definition at line 183 of file ZDbcCachedResultSet.pas.
Definition at line 175 of file ZDbcCachedResultSet.pas.
TList TZAbstractCachedResultSet::FRowsList [private] |
Definition at line 163 of file ZDbcCachedResultSet.pas.
Definition at line 169 of file ZDbcCachedResultSet.pas.
Definition at line 171 of file ZDbcCachedResultSet.pas.
TList TZAbstractCachedResultSet::InitialRowsList [protected] |
FInitialRowsList For writing
Definition at line 233 of file ZDbcCachedResultSet.pas.
PZRowBuffer TZAbstractCachedResultSet::InsertedRow [protected] |
FInsertedRow For writing
Definition at line 246 of file ZDbcCachedResultSet.pas.
Integer TZAbstractResultSet::LastRowNo [protected, inherited] |
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] |
Definition at line 157 of file ZDbcResultSet.pas.
TContainedObject TZAbstractResultSet::Metadata [protected, inherited] |
Definition at line 181 of file ZDbcResultSet.pas.
FNewRowAccessor For writing
Definition at line 257 of file ZDbcCachedResultSet.pas.
Integer TZAbstractCachedResultSet::NextRowIndex [protected] |
FNextRowIndex For writing
Definition at line 260 of file ZDbcCachedResultSet.pas.
FOldRowAccessor For writing
Definition at line 253 of file ZDbcCachedResultSet.pas.
IZCachedResolver TZAbstractCachedResultSet::Resolver [protected] |
Definition at line 263 of file ZDbcCachedResultSet.pas.
TZResultSetConcurrency TZAbstractResultSet::ResultSetConcurrency [protected, inherited] |
FResultSetConcurrency For writing
Definition at line 175 of file ZDbcResultSet.pas.
TZResultSetType TZAbstractResultSet::ResultSetType [protected, inherited] |
FResultSetType For writing
Definition at line 171 of file ZDbcResultSet.pas.
TZRowAccessor TZAbstractCachedResultSet::RowAccessor [protected] |
FRowAccessor For writing
Definition at line 249 of file ZDbcCachedResultSet.pas.
Integer TZAbstractResultSet::RowNo [protected, inherited] |
TList TZAbstractCachedResultSet::RowsList [protected] |
Definition at line 229 of file ZDbcCachedResultSet.pas.
PZRowBuffer TZAbstractCachedResultSet::SelectedRow [protected] |
FSelectedRow For writing
Definition at line 240 of file ZDbcCachedResultSet.pas.
IZStatement TZAbstractResultSet::Statement [protected, inherited] |
PZRowBuffer TZAbstractCachedResultSet::UpdatedRow [protected] |
FUpdatedRow For writing
Definition at line 243 of file ZDbcCachedResultSet.pas.