Public Member Functions | |
AddBatch (const string SQL) | |
Adds an SQL command to the current batch of commmands for this Statement object. | |
AddBatchPrepared () | |
Adds a set of parameters to this PreparedStatement object's batch of commands. | |
Cancel () | |
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement. | |
ClearBatch () | |
Makes the set of commands in the current batch empty. | |
ClearParameters () | |
Clears the current parameter values immediately. | |
ClearWarnings () | |
Clears all the warnings reported on this Statement object. | |
Close () | |
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. | |
Boolean | Execute (const string SQL) |
Executes an SQL statement that may return multiple results. | |
TIntegerDynArray | ExecuteBatch () |
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. | |
Boolean | ExecutePrepared () |
Executes any kind of SQL statement. | |
IZResultSet | ExecuteQuery (const string SQL) |
Executes an SQL statement that returns a single ResultSet object. | |
IZResultSet | ExecuteQueryPrepared () |
Executes the SQL query in this PreparedStatement object and returns the result set generated by the query. | |
Integer | ExecuteUpdate (const string SQL) |
Executes an SQL INSERT , UPDATE or DELETE statement. | |
Integer | ExecuteUpdatePrepared () |
Executes the SQL INSERT, UPDATE or DELETE statement in this PreparedStatement object. | |
Extended | GetBigDecimal (Integer ParameterIndex) |
Gets the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point. | |
Boolean | GetBoolean (Integer ParameterIndex) |
Gets the value of a JDBC BIT parameter as a boolean in the Java programming language. | |
ShortInt | GetByte (Integer ParameterIndex) |
Gets the value of a JDBC TINYINT parameter as a byte in the Java programming language. | |
TByteDynArray | GetBytes (Integer ParameterIndex) |
Gets the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language. | |
IZConnection | GetConnection () |
Returns the Connection object that produced this Statement object. | |
TDateTime | GetDate (Integer ParameterIndex) |
Gets the value of a JDBC DATE parameter as a java.sql.Date object. | |
Double | GetDouble (Integer ParameterIndex) |
Gets the value of a JDBC DOUBLE parameter as a double in the Java programming language. | |
TZFetchDirection | GetFetchDirection () |
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. | |
Integer | GetFetchSize () |
Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. | |
Single | GetFloat (Integer ParameterIndex) |
Gets the value of a JDBC FLOAT parameter as a float in the Java programming language. | |
Integer | GetInt (Integer ParameterIndex) |
Gets the value of a JDBC INTEGER parameter as an int in the Java programming language. | |
TZLocateUpdatesMode | GetLocateUpdates () |
Gets the current value for locate updates. | |
Int64 | GetLong (Integer ParameterIndex) |
Gets the value of a JDBC BIGINT parameter as a long in the Java programming language. | |
Integer | GetMaxFieldSize () |
Returns the maximum number of bytes allowed for any column value. | |
Integer | GetMaxRows () |
Retrieves the maximum number of rows that a ResultSet object can contain. | |
IZResultSetMetaData | GetMetaData () |
Gets the number, types and properties of a ResultSet object's columns. | |
Boolean | GetMoreResults () |
Moves to a Statement object's next result. | |
TStrings | GetParameters () |
Gets statement parameters. | |
PChar | GetPChar (Integer ParameterIndex) |
Retrieves the value of a JDBC CHAR , VARCHAR , or LONGVARCHAR parameter as a String in the Java programming language. | |
TZPostUpdatesMode | GetPostUpdates () |
Gets the current value for post updates. | |
Integer | GetQueryTimeout () |
Retrieves the number of seconds the driver will wait for a Statement object to execute. | |
IZResultSet | GetResultSet () |
Returns the current result as a ResultSet object. | |
TZResultSetConcurrency | GetResultSetConcurrency () |
Retrieves the result set concurrency for ResultSet objects generated by this Statement object. | |
TZResultSetType | GetResultSetType () |
Retrieves the result set type for ResultSet objects generated by this Statement object. | |
SmallInt | GetShort (Integer ParameterIndex) |
Gets the value of a JDBC SMALLINT parameter as a short in the Java programming language. | |
string | GetString (Integer ParameterIndex) |
Retrieves the value of a JDBC CHAR , VARCHAR , or LONGVARCHAR parameter as a String in the Java programming language. | |
TDateTime | GetTime (Integer ParameterIndex) |
Get the value of a JDBC TIME parameter as a java.sql.Time object. | |
TDateTime | GetTimestamp (Integer ParameterIndex) |
Gets the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object. | |
WideString | GetUnicodeString (Integer ParameterIndex) |
Retrieves the value of a JDBC CHAR , VARCHAR , or LONGVARCHAR parameter as a String in the Java programming language. | |
Integer | GetUpdateCount () |
Returns the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned. | |
TZVariant | GetValue (Integer ParameterIndex) |
Gets the value of a JDBC Variant parameter value. | |
EZSQLWarning | GetWarnings () |
Retrieves the first warning reported by calls on this Statement object. | |
Boolean | IsNull (Integer ParameterIndex) |
Indicates whether or not the specified OUT parameter read had the value of SQL NULL . | |
RegisterOutParameter (Integer ParameterIndex, Integer SQLType) | |
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType . | |
SetAsciiStream (Integer ParameterIndex, TStream Value) | |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. | |
SetBigDecimal (Integer ParameterIndex, Extended Value) | |
Sets the designated parameter to a java.math.BigDecimal value. | |
SetBinaryStream (Integer ParameterIndex, TStream Value) | |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. | |
SetBlob (Integer ParameterIndex, TZSQLType SQLType, IZBlob Value) | |
Sets a blob object for the specified parameter. | |
SetBoolean (Integer ParameterIndex, Boolean Value) | |
Sets the designated parameter to a Java boolean value. | |
SetByte (Integer ParameterIndex, ShortInt Value) | |
Sets the designated parameter to a Java byte value. | |
SetBytes (Integer ParameterIndex, const TByteDynArray Value) | |
Sets the designated parameter to a Java array of bytes. | |
SetCursorName (const string Value) | |
Defines the SQL cursor name that will be used by subsequent Statement object execute methods. | |
SetDate (Integer ParameterIndex, TDateTime Value) | |
Sets the designated parameter to a <code<java.sql.Date value. | |
SetDefaultValue (Integer ParameterIndex, const string Value) | |
Sets the designated parameter the default SQL value. | |
SetDouble (Integer ParameterIndex, Double Value) | |
Sets the designated parameter to a Java double value. | |
SetEscapeProcessing (Boolean Value) | |
Sets escape processing on or off. | |
SetFetchDirection (TZFetchDirection Value) | |
Gives the driver a hint as to the direction in which the rows in a result set will be processed. | |
SetFetchSize (Integer Value) | |
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. | |
SetFloat (Integer ParameterIndex, Single Value) | |
Sets the designated parameter to a Java float value. | |
SetInt (Integer ParameterIndex, Integer Value) | |
Sets the designated parameter to a Java int value. | |
SetLocateUpdates (TZLocateUpdatesMode Value) | |
Sets a new value for locate updates. | |
SetLong (Integer ParameterIndex, Int64 Value) | |
Sets the designated parameter to a Java long value. | |
SetMaxFieldSize (Integer Value) | |
Sets the limit for the maximum number of bytes in a column to the given number of bytes. | |
SetMaxRows (Integer Value) | |
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. | |
SetNull (Integer ParameterIndex, TZSQLType SQLType) | |
Sets the designated parameter to SQL NULL . | |
SetPChar (Integer ParameterIndex, PChar Value) | |
Sets the designated parameter to a Java String value. | |
SetPostUpdates (TZPostUpdatesMode Value) | |
Sets a new value for post updates. | |
SetQueryTimeout (Integer Value) | |
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds. | |
SetResultSetConcurrency (TZResultSetConcurrency Value) | |
Sets a result set concurrency for ResultSet objects generated by this Statement object. | |
SetResultSetType (TZResultSetType Value) | |
Sets a result set type for ResultSet objects generated by this Statement object. | |
SetShort (Integer ParameterIndex, SmallInt Value) | |
Sets the designated parameter to a Java short value. | |
SetString (Integer ParameterIndex, const string Value) | |
Sets the designated parameter to a Java String value. | |
SetTime (Integer ParameterIndex, TDateTime Value) | |
Sets the designated parameter to a java.sql.Time value. | |
SetTimestamp (Integer ParameterIndex, TDateTime Value) | |
Sets the designated parameter to a java.sql.Timestamp value. | |
SetUnicodeStream (Integer ParameterIndex, TStream Value) | |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. | |
SetUnicodeString (Integer ParameterIndex, const WideString Value) | |
Sets the designated parameter to a Object Pascal WideString value. | |
SetValue (Integer ParameterIndex, const TZVariant Value) | |
Sets a variant value for the specified parameter. | |
TZInterbase6CallableStatement (IZConnection Connection, const string SQL, TStrings Info) | |
Constructs this object and assignes the main properties. | |
Boolean | WasNull () |
Indicates whether or not the last OUT parameter read had the value of SQL NULL . | |
Protected Member Functions | |
CheckInterbase6Error (const string Sql= '') | |
Check interbase error status. | |
FetchOutParams (IZResultSQLDA Value) | |
Set output parameters values from IZResultSQLDA. | |
TZVariant | GetOutParam (Integer ParameterIndex) |
Gets a output parameter value by it's index. | |
string | GetProcedureSql (boolean SelectProc) |
Create sql string for calling stored procedure. | |
RaiseUnsupportedException () | |
Raises unsupported operation exception. | |
SetInParam (Integer ParameterIndex, TZSQLType SQLType, const TZVariant Value) | |
Sets a variant value into specified parameter. | |
SetInParamCount (Integer NewParamCount) | |
Sets a new parameter count and initializes the buffers. | |
SetOutParamCount (Integer NewParamCount) | |
Sets a new parameter count and initializes the buffers. | |
TrimInParameters () | |
Function remove stUnknown paramters from InParamTypes and InParamValues. | |
Protected Attributes | |
TStrings | BatchQueries |
Boolean | Closed |
IZConnection | Connection |
string | CursorName |
Boolean | EscapeProcessing |
TZFetchDirection | FetchDirection |
Integer | FetchSize |
TStrings | Info |
Integer | InParamCount |
TStringDynArray | InParamDefaultValues |
TZSQLTypeArray | InParamTypes |
TZVariantDynArray | InParamValues |
IZResultSet | LastResultSet |
Integer | LastUpdateCount |
Boolean | LastWasNull |
Integer | MaxFieldSize |
Integer | MaxRows |
Integer | OutParamCount |
TZSQLTypeArray | OutParamTypes |
TZVariantDynArray | OutParamValues |
Integer | QueryTimeout |
TZResultSetConcurrency | ResultSetConcurrency |
TZResultSetType | ResultSetType |
string | SQL |
Private Attributes | |
boolean | FCachedBlob |
IZInterbase6Connection | FIBConnection |
IZParamsSQLDA | FParamSQLData |
TARRAY_ISC_STATUS | FStatusVector |
Definition at line 157 of file ZDbcInterbase6Statement.pas.
TZInterbase6CallableStatement::TZInterbase6CallableStatement | ( | IZConnection | Connection, | |
const string | SQL, | |||
TStrings | Info | |||
) |
Constructs this object and assignes the main properties.
Connection | a database connection object. | |
Handle | a connection handle pointer. | |
Dialect | a dialect Interbase SQL must be 1 or 2 or 3. | |
Info | a statement parameters. |
Definition at line 824 of file ZDbcInterbase6Statement.pas.
TZAbstractStatement::AddBatch | ( | const string | SQL | ) | [inherited] |
Adds an SQL command to the current batch of commmands for this Statement
object.
This method is optional.
sql | typically this is a static SQL INSERT or UPDATE statement |
Reimplemented from IZStatement.
Definition at line 1349 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::AddBatchPrepared | ( | ) | [inherited] |
Adds a set of parameters to this PreparedStatement
object's batch of commands.
Reimplemented from IZPreparedStatement.
Definition at line 2196 of file ZDbcStatement.pas.
TZAbstractStatement::Cancel | ( | ) | [inherited] |
Cancels this Statement
object if both the DBMS and driver support aborting an SQL statement.
This method can be used by one thread to cancel a statement that is being executed by another thread.
Reimplemented from IZStatement.
Reimplemented in TZASAStatement, TZASAPreparedStatement, and TZASACallableStatement.
Definition at line 990 of file ZDbcStatement.pas.
TZInterbase6CallableStatement::CheckInterbase6Error | ( | const string | Sql = '' |
) | [protected] |
Check interbase error status.
Sql | the used sql tring |
Definition at line 807 of file ZDbcInterbase6Statement.pas.
TZAbstractStatement::ClearBatch | ( | ) | [inherited] |
Makes the set of commands in the current batch empty.
This method is optional.
Reimplemented from IZStatement.
Definition at line 1362 of file ZDbcStatement.pas.
TZAbstractCallableStatement::ClearParameters | ( | ) | [inherited] |
Clears the current parameter values immediately.
In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method clearParameters
.
Reimplemented from TZAbstractPreparedStatement.
Reimplemented in TZAdoPreparedStatement.
Definition at line 2272 of file ZDbcStatement.pas.
TZAbstractStatement::ClearWarnings | ( | ) | [inherited] |
Clears all the warnings reported on this Statement
object.
After a call to this method, the method getWarnings
will return null
until a new warning is reported for this Statement
object.
Reimplemented from IZStatement.
Reimplemented in TZASAStatement, TZASAPreparedStatement, and TZASACallableStatement.
Definition at line 1027 of file ZDbcStatement.pas.
TZAbstractStatement::Close | ( | ) | [inherited] |
Releases this Statement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.
Note: A Statement
object is automatically closed when it is garbage collected. When a Statement
object is closed, its current ResultSet
object, if one exists, is also closed.
Reimplemented from IZStatement.
Reimplemented in TZAdoStatement, TZAdoPreparedStatement, TZASAStatement, TZASAPreparedStatement, TZASACallableStatement, TZOraclePreparedStatement, and TZEmulatedPreparedStatement.
Definition at line 851 of file ZDbcStatement.pas.
Boolean TZInterbase6CallableStatement::Execute | ( | const string | SQL | ) |
Executes an SQL statement that may return multiple results.
Under some (uncommon) situations a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string. The methods execute
, getMoreResults
, getResultSet
, and getUpdateCount
let you navigate through multiple results.
The execute
method executes an SQL statement and indicates the form of the first result. You can then use the methods getResultSet
or getUpdateCount
to retrieve the result, and getMoreResults
to move to any subsequent result(s).
sql | any SQL statement |
true
if the next result is a ResultSet
object; false
if it is an update count or there are no more results getUpdateCount
getMoreResults
Reimplemented from TZAbstractStatement.
Definition at line 865 of file ZDbcInterbase6Statement.pas.
TIntegerDynArray TZAbstractStatement::ExecuteBatch | ( | ) | [inherited] |
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
The int
elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch. The elements in the array returned by the method executeBatch
may be one of the following:
-2
-- indicates that the command was processed successfully but that the number of rows affected is unknown
If one of the commands in a batch update fails to execute properly, this method throws a BatchUpdateException
, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behavior must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the method BatchUpdateException.getUpdateCounts
will contain as many elements as there are commands in the batch, and at least one of the elements will be the following:
-3
-- indicates that the command failed to execute successfully and occurs only if a driver continues to process commands after a command fails
A driver is not required to implement this method. The possible implementations and return values have been modified in the Java 2 SDK, Standard Edition, version 1.3 to accommodate the option of continuing to proccess commands in a batch update after a BatchUpdateException
obejct has been thrown.
Reimplemented from IZStatement.
Definition at line 1413 of file ZDbcStatement.pas.
Boolean TZInterbase6CallableStatement::ExecutePrepared | ( | ) |
Executes any kind of SQL statement.
Some prepared statements return multiple results; the execute
method handles these complex statements as well as the simpler form of statements handled by the methods executeQuery
and executeUpdate
.
Reimplemented from TZAbstractPreparedStatement.
Definition at line 884 of file ZDbcInterbase6Statement.pas.
IZResultSet TZInterbase6CallableStatement::ExecuteQuery | ( | const string | SQL | ) |
Executes an SQL statement that returns a single ResultSet
object.
sql | typically this is a static SQL SELECT statement |
ResultSet
object that contains the data produced by the given query; never null
Reimplemented from TZAbstractStatement.
Definition at line 958 of file ZDbcInterbase6Statement.pas.
IZResultSet TZInterbase6CallableStatement::ExecuteQueryPrepared | ( | ) |
Executes the SQL query in this PreparedStatement
object and returns the result set generated by the query.
ResultSet
object that contains the data produced by the query; never null
Reimplemented from TZAbstractPreparedStatement.
Definition at line 976 of file ZDbcInterbase6Statement.pas.
References Create().
Integer TZInterbase6CallableStatement::ExecuteUpdate | ( | const string | SQL | ) |
Executes an SQL INSERT
, UPDATE
or DELETE
statement.
In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed.
sql | an SQL INSERT , UPDATE or DELETE statement or an SQL statement that returns nothing |
INSERT
, UPDATE
or DELETE
statements, or 0 for SQL statements that return nothing Reimplemented from TZAbstractStatement.
Definition at line 1046 of file ZDbcInterbase6Statement.pas.
Integer TZInterbase6CallableStatement::ExecuteUpdatePrepared | ( | ) |
Executes the SQL INSERT, UPDATE or DELETE statement in this PreparedStatement
object.
In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed.
Reimplemented from TZAbstractPreparedStatement.
Definition at line 1066 of file ZDbcInterbase6Statement.pas.
TZInterbase6CallableStatement::FetchOutParams | ( | IZResultSQLDA | Value | ) | [protected] |
Set output parameters values from IZResultSQLDA.
Value | a IZResultSQLDA object. |
Definition at line 1122 of file ZDbcInterbase6Statement.pas.
Extended TZAbstractCallableStatement::GetBigDecimal | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC NUMERIC
parameter as a java.math.BigDecimal
object with scale digits to the right of the decimal point.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2577 of file ZDbcStatement.pas.
Boolean TZAbstractCallableStatement::GetBoolean | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC BIT
parameter as a boolean
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is false
. Reimplemented from IZCallableStatement.
Definition at line 2456 of file ZDbcStatement.pas.
ShortInt TZAbstractCallableStatement::GetByte | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC TINYINT
parameter as a byte
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2473 of file ZDbcStatement.pas.
TByteDynArray TZAbstractCallableStatement::GetBytes | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC BINARY
or VARBINARY
parameter as an array of byte
values in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2596 of file ZDbcStatement.pas.
IZConnection TZAbstractStatement::GetConnection | ( | ) | [inherited] |
Returns the Connection
object that produced this Statement
object.
Reimplemented from IZStatement.
Definition at line 1436 of file ZDbcStatement.pas.
TDateTime TZAbstractCallableStatement::GetDate | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC DATE
parameter as a java.sql.Date
object.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2614 of file ZDbcStatement.pas.
Double TZAbstractCallableStatement::GetDouble | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC DOUBLE
parameter as a double
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2558 of file ZDbcStatement.pas.
TZFetchDirection TZAbstractStatement::GetFetchDirection | ( | ) | [inherited] |
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement
object.
If this Statement
object has not set a fetch direction by calling the method setFetchDirection
, the return value is implementation-specific.
Statement
object Reimplemented from IZStatement.
Definition at line 1163 of file ZDbcStatement.pas.
Integer TZAbstractStatement::GetFetchSize | ( | ) | [inherited] |
Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement
object.
If this Statement
object has not set a fetch size by calling the method setFetchSize
, the return value is implementation-specific.
Statement
object Reimplemented from IZStatement.
Definition at line 1202 of file ZDbcStatement.pas.
Single TZAbstractCallableStatement::GetFloat | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC FLOAT
parameter as a float
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2541 of file ZDbcStatement.pas.
Integer TZAbstractCallableStatement::GetInt | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC INTEGER
parameter as an int
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2507 of file ZDbcStatement.pas.
TZLocateUpdatesMode TZAbstractStatement::GetLocateUpdates | ( | ) | [inherited] |
Gets the current value for locate updates.
Reimplemented from IZStatement.
Definition at line 1296 of file ZDbcStatement.pas.
Int64 TZAbstractCallableStatement::GetLong | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC BIGINT
parameter as a long
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2524 of file ZDbcStatement.pas.
Integer TZAbstractStatement::GetMaxFieldSize | ( | ) | [inherited] |
Returns the maximum number of bytes allowed for any column value.
This limit is the maximum number of bytes that can be returned for any column value. The limit applies only to BINARY
, VARBINARY
, LONGVARBINARY
, CHAR
, VARCHAR
, and LONGVARCHAR
columns. If the limit is exceeded, the excess data is silently discarded.
Reimplemented from IZStatement.
Definition at line 873 of file ZDbcStatement.pas.
Integer TZAbstractStatement::GetMaxRows | ( | ) | [inherited] |
Retrieves the maximum number of rows that a ResultSet
object can contain.
If the limit is exceeded, the excess rows are silently dropped.
Reimplemented from IZStatement.
Definition at line 909 of file ZDbcStatement.pas.
IZResultSetMetaData TZAbstractPreparedStatement::GetMetaData | ( | ) | [inherited] |
Gets the number, types and properties of a ResultSet
object's columns.
ResultSet
object's columns Reimplemented in TZDBLibPreparedStatementEmulated.
Definition at line 2208 of file ZDbcStatement.pas.
Boolean TZAbstractStatement::GetMoreResults | ( | ) | [inherited] |
Moves to a Statement
object's next result.
It returns true
if this result is a ResultSet
object. This method also implicitly closes any current ResultSet
object obtained with the method getResultSet
.
There are no more results when the following is true:
(!getMoreResults() && (getUpdateCount() == -1)
true
if the next result is a ResultSet
object; false
if it is an update count or there are no more results Reimplemented from IZStatement.
Reimplemented in TZAdoStatement, TZASAStatement, TZASAPreparedStatement, TZASACallableStatement, TZDBLibStatement, TZDBLibCallableStatement, and TZMySQLStatement.
Definition at line 1144 of file ZDbcStatement.pas.
TZVariant TZAbstractCallableStatement::GetOutParam | ( | Integer | ParameterIndex | ) | [protected, inherited] |
Gets a output parameter value by it's index.
ParameterIndex | a parameter index. |
Reimplemented in TZAdoCallableStatement.
Definition at line 2327 of file ZDbcStatement.pas.
TStrings TZAbstractStatement::GetParameters | ( | ) | [inherited] |
Gets statement parameters.
Reimplemented from IZStatement.
Definition at line 1448 of file ZDbcStatement.pas.
PChar TZAbstractCallableStatement::GetPChar | ( | Integer | ParameterIndex | ) | [inherited] |
Retrieves the value of a JDBC CHAR
, VARCHAR
, or LONGVARCHAR
parameter as a String
in the Java programming language.
For the fixed-length type JDBC CHAR
, the String
object returned has exactly the same value the JDBC CHAR
value had in the database, including any padding added by the database.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. SQLException | if a database access error occurs |
Reimplemented from IZCallableStatement.
Definition at line 2388 of file ZDbcStatement.pas.
TZPostUpdatesMode TZAbstractStatement::GetPostUpdates | ( | ) | [inherited] |
Gets the current value for post updates.
Reimplemented from IZStatement.
Definition at line 1321 of file ZDbcStatement.pas.
string TZInterbase6CallableStatement::GetProcedureSql | ( | boolean | SelectProc | ) | [protected] |
Create sql string for calling stored procedure.
SelectProc | indicate use EXECUTE PROCEDURE or SELECT staement |
Definition at line 1180 of file ZDbcInterbase6Statement.pas.
Integer TZAbstractStatement::GetQueryTimeout | ( | ) | [inherited] |
Retrieves the number of seconds the driver will wait for a Statement
object to execute.
If the limit is exceeded, a SQLException
is thrown.
Reimplemented from IZStatement.
Definition at line 960 of file ZDbcStatement.pas.
IZResultSet TZAbstractStatement::GetResultSet | ( | ) | [inherited] |
Returns the current result as a ResultSet
object.
This method should be called only once per result.
ResultSet
object; null
if the result is an update count or there are no more results Reimplemented from IZStatement.
Definition at line 1104 of file ZDbcStatement.pas.
TZResultSetConcurrency TZAbstractStatement::GetResultSetConcurrency | ( | ) | [inherited] |
Retrieves the result set concurrency for ResultSet
objects generated by this Statement
object.
ResultSet.CONCUR_READ_ONLY
or ResultSet.CONCUR_UPDATABLE
Reimplemented from IZStatement.
Definition at line 1251 of file ZDbcStatement.pas.
TZResultSetType TZAbstractStatement::GetResultSetType | ( | ) | [inherited] |
Retrieves the result set type for ResultSet
objects generated by this Statement
object.
ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
Reimplemented from IZStatement.
Definition at line 1284 of file ZDbcStatement.pas.
SmallInt TZAbstractCallableStatement::GetShort | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC SMALLINT
parameter as a short
in the Java programming language.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is 0. Reimplemented from IZCallableStatement.
Definition at line 2490 of file ZDbcStatement.pas.
string TZAbstractCallableStatement::GetString | ( | Integer | ParameterIndex | ) | [inherited] |
Retrieves the value of a JDBC CHAR
, VARCHAR
, or LONGVARCHAR
parameter as a String
in the Java programming language.
For the fixed-length type JDBC CHAR
, the String
object returned has exactly the same value the JDBC CHAR
value had in the database, including any padding added by the database.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. SQLException | if a database access error occurs |
Reimplemented from IZCallableStatement.
Definition at line 2414 of file ZDbcStatement.pas.
TDateTime TZAbstractCallableStatement::GetTime | ( | Integer | ParameterIndex | ) | [inherited] |
Get the value of a JDBC TIME
parameter as a java.sql.Time
object.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2632 of file ZDbcStatement.pas.
TDateTime TZAbstractCallableStatement::GetTimestamp | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC TIMESTAMP
parameter as a java.sql.Timestamp
object.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2650 of file ZDbcStatement.pas.
WideString TZAbstractCallableStatement::GetUnicodeString | ( | Integer | ParameterIndex | ) | [inherited] |
Retrieves the value of a JDBC CHAR
, VARCHAR
, or LONGVARCHAR
parameter as a String
in the Java programming language.
For the fixed-length type JDBC CHAR
, the WideString
object returned has exactly the same value the JDBC CHAR
value had in the database, including any padding added by the database.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. SQLException | if a database access error occurs |
Reimplemented from IZCallableStatement.
Definition at line 2439 of file ZDbcStatement.pas.
Integer TZAbstractStatement::GetUpdateCount | ( | ) | [inherited] |
Returns the current result as an update count; if the result is a ResultSet
object or there are no more results, -1 is returned.
This method should be called only once per result.
ResultSet
object or there are no more results Reimplemented from IZStatement.
Definition at line 1121 of file ZDbcStatement.pas.
TZVariant TZAbstractCallableStatement::GetValue | ( | Integer | ParameterIndex | ) | [inherited] |
Gets the value of a JDBC Variant
parameter value.
parameterIndex | the first parameter is 1, the second is 2, and so on |
NULL
, the result is null
. Reimplemented from IZCallableStatement.
Definition at line 2667 of file ZDbcStatement.pas.
EZSQLWarning TZAbstractStatement::GetWarnings | ( | ) | [inherited] |
Retrieves the first warning reported by calls on this Statement
object.
Subsequent Statement
object warnings will be chained to this SQLWarning
object.
The warning chain is automatically cleared each time a statement is (re)executed.
Note: If you are processing a ResultSet
object, any warnings associated with reads on that ResultSet
object will be chained on it.
SQLWarning
object or null
Reimplemented from IZStatement.
Reimplemented in TZASAStatement, TZASAPreparedStatement, and TZASACallableStatement.
Definition at line 1012 of file ZDbcStatement.pas.
Boolean TZAbstractCallableStatement::IsNull | ( | Integer | ParameterIndex | ) | [inherited] |
Indicates whether or not the specified OUT parameter read had the value of SQL NULL
.
true
if the parameter read was SQL NULL
; false
otherwise Reimplemented from IZCallableStatement.
Definition at line 2362 of file ZDbcStatement.pas.
TZAbstractStatement::RaiseUnsupportedException | ( | ) | [protected, inherited] |
TZAbstractCallableStatement::RegisterOutParameter | ( | Integer | ParameterIndex, | |
Integer | SQLType | |||
) | [inherited] |
Registers the OUT parameter in ordinal position parameterIndex
to the JDBC type sqlType
.
All OUT parameters must be registered before a stored procedure is executed.
The JDBC type specified by sqlType
for an OUT parameter determines the Java type that must be used in the get
method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType
should be java.sql.Types.OTHER
. The method retrieves the value.
parameterIndex | the first parameter is 1, the second is 2, and so on | |
sqlType | the JDBC type code defined by java.sql.Types . If the parameter is of JDBC type NUMERIC or DECIMAL , the version of registerOutParameter that accepts a scale value should be used. |
Reimplemented from IZCallableStatement.
Reimplemented in TZDBLibCallableStatement.
Definition at line 2311 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetAsciiStream | ( | Integer | ParameterIndex, | |
TStream | Value | |||
) | [inherited] |
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
When a very large ASCII value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the Java input stream that contains the ASCII parameter value | |
length | the number of bytes in the stream |
Reimplemented from IZPreparedStatement.
Definition at line 2028 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetBigDecimal | ( | Integer | ParameterIndex, | |
Extended | Value | |||
) | [inherited] |
Sets the designated parameter to a java.math.BigDecimal
value.
The driver converts this to an SQL NUMERIC
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1801 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetBinaryStream | ( | Integer | ParameterIndex, | |
TStream | Value | |||
) | [inherited] |
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
When a very large binary value is input to a LONGVARBINARY
parameter, it may be more practical to send it via a java.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the java input stream which contains the binary parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 2081 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetBlob | ( | Integer | ParameterIndex, | |
TZSQLType | SQLType, | |||
IZBlob | Value | |||
) | [inherited] |
Sets a blob object for the specified parameter.
ParameterIndex | the first parameter is 1, the second is 2, ... | |
Value | the java blob object. |
Reimplemented from IZPreparedStatement.
Definition at line 2096 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetBoolean | ( | Integer | ParameterIndex, | |
Boolean | Value | |||
) | [inherited] |
Sets the designated parameter to a Java boolean
value.
The driver converts this to an SQL BIT
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1619 of file ZDbcStatement.pas.
References p.
TZAbstractPreparedStatement::SetByte | ( | Integer | ParameterIndex, | |
ShortInt | Value | |||
) | [inherited] |
Sets the designated parameter to a Java byte
value.
The driver converts this to an SQL TINYINT
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1645 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetBytes | ( | Integer | ParameterIndex, | |
const TByteDynArray | Value | |||
) | [inherited] |
Sets the designated parameter to a Java array of bytes.
The driver converts this to an SQL VARBINARY
or LONGVARBINARY
(depending on the argument's size relative to the driver's limits on VARBINARY
values) when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1915 of file ZDbcStatement.pas.
TZAbstractStatement::SetCursorName | ( | const string | Value | ) | [inherited] |
Defines the SQL cursor name that will be used by subsequent Statement
object execute
methods.
This name can then be used in SQL positioned update/delete statements to identify the current row in the ResultSet
object generated by this statement. If the database doesn't support positioned update/delete, this method is a noop. To insure that a cursor has the proper isolation level to support updates, the cursor's SELECT
statement should be of the form 'select for update ...'. If the 'for update' phrase is omitted, positioned updates may fail.
Note: By definition, positioned update/delete execution must be done by a different Statement
object than the one which generated the ResultSet
object being used for positioning. Also, cursor names must be unique within a connection.
name | the new cursor name, which must be unique within a connection |
Reimplemented from IZStatement.
Definition at line 1053 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetDate | ( | Integer | ParameterIndex, | |
TDateTime | Value | |||
) | [inherited] |
Sets the designated parameter to a <code<java.sql.Date value.
The driver converts this to an SQL DATE
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1941 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetDefaultValue | ( | Integer | ParameterIndex, | |
const string | Value | |||
) | [inherited] |
Sets the designated parameter the default SQL value.
Note: You must specify the default value.
parameterIndex | the first parameter is 1, the second is 2, ... | |
Value | the default value normally defined in the field's DML SQL statement |
Reimplemented from IZPreparedStatement.
Definition at line 1581 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetDouble | ( | Integer | ParameterIndex, | |
Double | Value | |||
) | [inherited] |
Sets the designated parameter to a Java double
value.
The driver converts this to an SQL DOUBLE
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1775 of file ZDbcStatement.pas.
TZAbstractStatement::SetEscapeProcessing | ( | Boolean | Value | ) | [inherited] |
Sets escape processing on or off.
If escape scanning is on (the default), the driver will do escape substitution before sending the SQL to the database.
Note: Since prepared statements have usually been parsed prior to making this call, disabling escape processing for prepared statements will have no effect.
enable | true to enable; false to disable |
Reimplemented from IZStatement.
Definition at line 944 of file ZDbcStatement.pas.
TZAbstractStatement::SetFetchDirection | ( | TZFetchDirection | Value | ) | [inherited] |
Gives the driver a hint as to the direction in which the rows in a result set will be processed.
The hint applies only to result sets created using this Statement
object. The default value is ResultSet.FETCH_FORWARD
.
Note that this method sets the default fetch direction for result sets generated by this Statement
object. Each result set has its own methods for getting and setting its own fetch direction.
direction | the initial direction for processing rows |
Reimplemented from IZStatement.
Definition at line 1183 of file ZDbcStatement.pas.
TZAbstractStatement::SetFetchSize | ( | Integer | Value | ) | [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.
The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero.
rows | the number of rows to fetch |
Reimplemented from IZStatement.
Definition at line 1219 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetFloat | ( | Integer | ParameterIndex, | |
Single | Value | |||
) | [inherited] |
Sets the designated parameter to a Java float
value.
The driver converts this to an SQL FLOAT
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1749 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetInParam | ( | Integer | ParameterIndex, | |
TZSQLType | SQLType, | |||
const TZVariant | Value | |||
) | [protected, inherited] |
Sets a variant value into specified parameter.
ParameterIndex | a index of the parameter. | |
SqlType | a parameter SQL type. Value a new parameter value. |
Reimplemented in TZAdoPreparedStatement.
Definition at line 1524 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetInParamCount | ( | Integer | NewParamCount | ) | [protected, inherited] |
Sets a new parameter count and initializes the buffers.
NewParamCount | a new parameters count. |
Reimplemented in TZAdoPreparedStatement, and TZDBLibCallableStatement.
Definition at line 1494 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetInt | ( | Integer | ParameterIndex, | |
Integer | Value | |||
) | [inherited] |
Sets the designated parameter to a Java int
value.
The driver converts this to an SQL INTEGER
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1697 of file ZDbcStatement.pas.
TZAbstractStatement::SetLocateUpdates | ( | TZLocateUpdatesMode | Value | ) | [inherited] |
Sets a new value for locate updates.
Value | a new value for locate updates. |
Reimplemented from IZStatement.
Definition at line 1308 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetLong | ( | Integer | ParameterIndex, | |
Int64 | Value | |||
) | [inherited] |
Sets the designated parameter to a Java long
value.
The driver converts this to an SQL BIGINT
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1723 of file ZDbcStatement.pas.
TZAbstractStatement::SetMaxFieldSize | ( | Integer | Value | ) | [inherited] |
Sets the limit for the maximum number of bytes in a column to the given number of bytes.
This is the maximum number of bytes that can be returned for any column value. This limit applies only to BINARY
, VARBINARY
, LONGVARBINARY
, CHAR
, VARCHAR
, and LONGVARCHAR
fields. If the limit is exceeded, the excess data is silently discarded. For maximum portability, use values greater than 256.
max | the new max column size limit; zero means unlimited |
Reimplemented from IZStatement.
Definition at line 893 of file ZDbcStatement.pas.
TZAbstractStatement::SetMaxRows | ( | Integer | Value | ) | [inherited] |
Sets the limit for the maximum number of rows that any ResultSet
object can contain to the given number.
If the limit is exceeded, the excess rows are silently dropped.
max | the new max rows limit; zero means unlimited |
Reimplemented from IZStatement.
Definition at line 924 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetNull | ( | Integer | ParameterIndex, | |
TZSQLType | SQLType | |||
) | [inherited] |
Sets the designated parameter to SQL NULL
.
Note: You must specify the parameter's SQL type.
parameterIndex | the first parameter is 1, the second is 2, ... | |
sqlType | the SQL type code defined in java.sql.Types |
Reimplemented from IZPreparedStatement.
Definition at line 1601 of file ZDbcStatement.pas.
TZAbstractCallableStatement::SetOutParamCount | ( | Integer | NewParamCount | ) | [protected, inherited] |
Sets a new parameter count and initializes the buffers.
NewParamCount | a new parameters count. |
Definition at line 2243 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetPChar | ( | Integer | ParameterIndex, | |
PChar | Value | |||
) | [inherited] |
Sets the designated parameter to a Java String
value.
The driver converts this to an SQL VARCHAR
or LONGVARCHAR
value (depending on the argument's size relative to the driver's limits on VARCHAR
values) when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1830 of file ZDbcStatement.pas.
TZAbstractStatement::SetPostUpdates | ( | TZPostUpdatesMode | Value | ) | [inherited] |
Sets a new value for post updates.
Value | a new value for post updates. |
Reimplemented from IZStatement.
Definition at line 1333 of file ZDbcStatement.pas.
References P.
TZAbstractStatement::SetQueryTimeout | ( | Integer | Value | ) | [inherited] |
Sets the number of seconds the driver will wait for a Statement
object to execute to the given number of seconds.
If the limit is exceeded, an SQLException
is thrown.
seconds | the new query timeout limit in seconds; zero means unlimited |
Reimplemented from IZStatement.
Definition at line 975 of file ZDbcStatement.pas.
TZAbstractStatement::SetResultSetConcurrency | ( | TZResultSetConcurrency | Value | ) | [inherited] |
Sets a result set concurrency for ResultSet
objects generated by this Statement
object.
Concurrency | either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE |
Reimplemented from IZStatement.
Definition at line 1235 of file ZDbcStatement.pas.
TZAbstractStatement::SetResultSetType | ( | TZResultSetType | Value | ) | [inherited] |
Sets a result set type for ResultSet
objects generated by this Statement
object.
ResultSetType | one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
Reimplemented from IZStatement.
Definition at line 1267 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetShort | ( | Integer | ParameterIndex, | |
SmallInt | Value | |||
) | [inherited] |
Sets the designated parameter to a Java short
value.
The driver converts this to an SQL SMALLINT
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1671 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetString | ( | Integer | ParameterIndex, | |
const string | Value | |||
) | [inherited] |
Sets the designated parameter to a Java String
value.
The driver converts this to an SQL VARCHAR
or LONGVARCHAR
value (depending on the argument's size relative to the driver's limits on VARCHAR
values) when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1859 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetTime | ( | Integer | ParameterIndex, | |
TDateTime | Value | |||
) | [inherited] |
Sets the designated parameter to a java.sql.Time
value.
The driver converts this to an SQL TIME
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1967 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetTimestamp | ( | Integer | ParameterIndex, | |
TDateTime | Value | |||
) | [inherited] |
Sets the designated parameter to a java.sql.Timestamp
value.
The driver converts this to an SQL TIMESTAMP
value when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1993 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetUnicodeStream | ( | Integer | ParameterIndex, | |
TStream | Value | |||
) | [inherited] |
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a java.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format. The byte format of the Unicode stream must be Java UTF-8, as defined in the Java Virtual Machine Specification.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the java input stream which contains the UNICODE parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 2056 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetUnicodeString | ( | Integer | ParameterIndex, | |
const WideString | Value | |||
) | [inherited] |
Sets the designated parameter to a Object Pascal WideString
value.
The driver converts this to an SQL VARCHAR
or LONGVARCHAR
value (depending on the argument's size relative to the driver's limits on VARCHAR
values) when it sends it to the database.
parameterIndex | the first parameter is 1, the second is 2, ... | |
x | the parameter value |
Reimplemented from IZPreparedStatement.
Definition at line 1888 of file ZDbcStatement.pas.
TZAbstractPreparedStatement::SetValue | ( | Integer | ParameterIndex, | |
const TZVariant | Value | |||
) | [inherited] |
Sets a variant value for the specified parameter.
ParameterIndex | the first parameter is 1, the second is 2, ... | |
Value | the variant value. |
Reimplemented from IZPreparedStatement.
Definition at line 2122 of file ZDbcStatement.pas.
TZInterbase6CallableStatement::TrimInParameters | ( | ) | [protected] |
Function remove stUnknown paramters from InParamTypes and InParamValues.
Definition at line 1226 of file ZDbcInterbase6Statement.pas.
Boolean TZAbstractCallableStatement::WasNull | ( | ) | [inherited] |
Indicates whether or not the last OUT parameter read had the value of SQL NULL
.
Note that this method should be called only after calling a getXXX
method; otherwise, there is no value to use in determining whether it is null
or not.
true
if the last parameter read was SQL NULL
; false
otherwise Reimplemented from IZCallableStatement.
Definition at line 2348 of file ZDbcStatement.pas.
TStrings TZAbstractStatement::BatchQueries [protected, inherited] |
Boolean TZAbstractStatement::Closed [protected, inherited] |
IZConnection TZAbstractStatement::Connection [protected, inherited] |
string TZAbstractStatement::CursorName [protected, inherited] |
FCursorName For writing
Definition at line 158 of file ZDbcStatement.pas.
Boolean TZAbstractStatement::EscapeProcessing [protected, inherited] |
FEscapeProcessing For writing
Definition at line 129 of file ZDbcStatement.pas.
boolean TZInterbase6CallableStatement::FCachedBlob [private] |
Definition at line 162 of file ZDbcInterbase6Statement.pas.
TZFetchDirection TZAbstractStatement::FetchDirection [protected, inherited] |
FFetchDirection For writing
Definition at line 144 of file ZDbcStatement.pas.
Integer TZAbstractStatement::FetchSize [protected, inherited] |
FFetchSize For writing
Definition at line 147 of file ZDbcStatement.pas.
Definition at line 168 of file ZDbcInterbase6Statement.pas.
Definition at line 164 of file ZDbcInterbase6Statement.pas.
Definition at line 166 of file ZDbcInterbase6Statement.pas.
TStrings TZAbstractStatement::Info [protected, inherited] |
Integer TZAbstractPreparedStatement::InParamCount [protected, inherited] |
FInParamCount For writing
Definition at line 358 of file ZDbcStatement.pas.
TStringDynArray TZAbstractPreparedStatement::InParamDefaultValues [protected, inherited] |
FInParamDefaultValues For writing
Definition at line 355 of file ZDbcStatement.pas.
TZSQLTypeArray TZAbstractPreparedStatement::InParamTypes [protected, inherited] |
FInParamTypes For writing
Definition at line 351 of file ZDbcStatement.pas.
TZVariantDynArray TZAbstractPreparedStatement::InParamValues [protected, inherited] |
FInParamValues For writing
Definition at line 347 of file ZDbcStatement.pas.
IZResultSet TZAbstractStatement::LastResultSet [protected, inherited] |
SetLastResultSet For writing
Definition at line 140 of file ZDbcStatement.pas.
Integer TZAbstractStatement::LastUpdateCount [protected, inherited] |
FLastUpdateCount For writing
Definition at line 136 of file ZDbcStatement.pas.
Boolean TZAbstractCallableStatement::LastWasNull [protected, inherited] |
FLastWasNull For writing
Definition at line 546 of file ZDbcStatement.pas.
Integer TZAbstractStatement::MaxFieldSize [protected, inherited] |
FMaxFieldSize For writing
Definition at line 122 of file ZDbcStatement.pas.
Integer TZAbstractStatement::MaxRows [protected, inherited] |
Definition at line 125 of file ZDbcStatement.pas.
Integer TZAbstractCallableStatement::OutParamCount [protected, inherited] |
FOutParamCount For writing
Definition at line 543 of file ZDbcStatement.pas.
TZSQLTypeArray TZAbstractCallableStatement::OutParamTypes [protected, inherited] |
FOutParamTypes For writing
Definition at line 540 of file ZDbcStatement.pas.
TZVariantDynArray TZAbstractCallableStatement::OutParamValues [protected, inherited] |
FOutParamValues For writing
Definition at line 532 of file ZDbcStatement.pas.
Integer TZAbstractStatement::QueryTimeout [protected, inherited] |
FQueryTimeout For writing
Definition at line 132 of file ZDbcStatement.pas.
TZResultSetConcurrency TZAbstractStatement::ResultSetConcurrency [protected, inherited] |
FResultSetConcurrency For writing
Definition at line 151 of file ZDbcStatement.pas.
TZResultSetType TZAbstractStatement::ResultSetType [protected, inherited] |
FResultSetType For writing
Definition at line 155 of file ZDbcStatement.pas.
string TZAbstractPreparedStatement::SQL [protected, inherited] |