Initialises the pointer to the implementation object to NULL.

Sets the parameter to the specified 64-bit integer value.

The parameter is identified by the specified index value.

Sets the parameter to a NULL value.

The parameter is identified by the specified index value.

Sets the parameter to the specified 64-bit floating point value.

The parameter is identified by the specified index value.

Sets the parameter to the specified 16-bit descriptor.

The parameter is identified by the specified index value.

Note that when the text data to be bound is over 2Mb in size then use of the RSqlBlobWriteStream or TSqlBlob class should be considered instead.

These classes provide a more RAM-efficient way of writing large amounts of text data to a database, however no conversions are performed on the text data - it is simply stored as a stream of bytes. If the text data is part of a record to be inserted into a database then BindZeroBlob() should be called on the INSERT statement to create a placeholder for the text data, whose content can then be written using the above classes.

Binds a blob of length aBlobSize bytes that is filled with zeroes.

The parameter is identified by the specified index value.

A zeroblob acts as a placeholder for a blob whose binary content is later written using the RSqlBlobWriteStream or TSqlBlob class.

Using zeroblobs provides a much more RAM-efficient way of creating large blobs than including the blob data in the INSERT statement and it is recommended for blobs that are over 2Mb in size.

Note that a zeroblob should be created in a column after which there are no columns that contain anything other than zeroblobs or NULLs, otherwise the zeroblob must be allocated in full in RAM and its benefit is lost.

When creating a zeroblob it is recommended, where possible, to create the zeroblob and then write the blob content (using the RSqlBlobWriteStream or TSqlBlob class) within the same transaction. Otherwise the zeroblob will have to be journalled before being written to.

Gets the value of the column as an 8-bit descriptor (leaves on failure).

The column is identified by the specified index value.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Note that when the binary data to be retrieved is over 2Mb in size then it is recommended that the RSqlBlobReadStream or TSqlBlob class is used instead. These classes provide a more RAM-efficient way of retrieving large amounts of binary data from a database.

Gets the index (starting from 0) of the column with the given name.

The function does a case insensitive column name search.

This function can be called at any time after the SQL statement has been prepared.

Gets the value of the column as a 64-bit integer.

The column is identified by the specified index value.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Obtain the name of a column after preparing a query.

Gets the value of the column as a 64-bit floating point value.

The column is identified by the specified index value.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Gets the value of the column as a 16-bit descriptor (leaves on failure).

The column is identified by the specified index value.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Note that when the text to be retrieved is over 2Mb in size then it is recommended that the RSqlBlobReadStream or TSqlBlob class is used instead. These classes provide a more RAM-efficient way of retrieving large amounts of text data from a database.

Gets the runtime type of the column identified by the specified column index.

This function returns the actual runtime datatype of the specified column as opposed to its declared type.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Gets the declared type of the column identified by the specified column index.

Note that the function can only be called when executing a SELECT query, and only after a successful call to Prepare().

This function returns the datatype that the specified column was originally declared to have.

 - if the column type name contains the string "INT", then the declared column type is ESqlInt;
 - if the column type name contains any of the strings "CHAR, "TEXT" or "CLOB", then the declared column type is ESqlText;
 - if the column type name contains any of the strings "BLOB" or "BINARY", then the declared column type is ESqlBinary;
 - if the column type name contains any of the strings "FLOAT", "REAL" or "DOUBLE", then the declared column type is ESqlReal;
 - in all other cases the declared column type is assumed to be ESqlInt;

Returns a reference to the implementation object of RSqlStatement - CSqlStatementImpl.

Tests whether the value of the specified column is NULL.

The column is identified by the specified index value.

Note that the function can only be called after a successful call to Next(), i.e. after a call to Next() that has completed with a KSqlAtRow return code. Calling this function after an unsuccessful call to Next() raises a panic.

Retrieves a record.

If the prepared SQL statement is a "SELECT" statement, and is expected to return a set of records, then this function can be used to retrieve that record data.

If the SQL statement contains parameters, then their values must be bound before this function is called.

If the call to this function completes successfully, i.e. it returns with KSqlAtRow, then this RSqlStatement object contains the record data, and this data will remain valid for access until another call is made to any RSqlStatement function.

Note that if this call to Next() fails, as indicated by a return code value other than KSqlAtRow, then calls to these RSqlStatement::Column...() functions will raise a panic.

Obtain the name of a parameter after preparing a DML query. The parameter names are returned in exactly the same form as supplied in SQL statement. For example, if the parameter name is ":Prm", then the ":" prefix will not be omitted.

ParamName has the same behaviour as ParameterName. It is provided to maintain source compatibility with previous Symbian releases.

This function can be called at any time after the DML SQL statement has been prepared.

Gets the index (starting from 0) of the parameter with the given name.

The function does a case insensitive parameter name search.

For example, if the parameter name is ":Prm", then the ":" prefix cannot be omitted when you call ParameterIndex().

This function can be called at any time after the SQL statement has been prepared.

Obtain the name of a parameter after preparing a DML query. The parameter names are returned in exactly the same form as supplied in SQL statement. For example, if the parameter name is ":Prm", then the ":" prefix will not be omitted.

This function can be called at any time after the DML SQL statement has been prepared.

Prepares the supplied 16-bit SQL statement for execution.

An RSqlStatement object can prepare and execute a parameterised SQL statement or an SQL statement without parameters.

The function can only deal with one SQL statement at a time, i.e. if you supply more than one SQL statement, each separated by a ";" character, then the function returns an error.

Note that when the statement is to be used to retrieve or write blob or text data that is over 2Mb in size then it is recommended that the RSqlBlobReadStream and RSqlBlobWriteStream classes or the TSqlBlob class is used instead. These classes provide a more RAM-efficient way of reading and writing large amounts of blob or text data from a database.

Resets the prepared SQL statement to its initial state and makes it ready to be executed again.

Any SQL statement parameters that had values bound to them, retain their values.

If this object processes a parameterised SQL statement, then the parameter values can be bound after the call to Reset().

If the call to this function fails because of a database-specific type error (i.e. the error is categorised as of type ESqlDbError), then a textual description of the error can be obtained calling RSqlDatabase::LastErrorMessage().

Usage pattern 1:

RSqlStatement stmt;
TInt err = stmt.Prepare(<database>, <SQL statement>);
while(<condition>)
	{
	err = stmt.Bind<parameter type>(<parameter index>, <value>);
	...
	err = stmt.Exec();
	....
	err = stmt.Reset();
	}
stmt.Close();

Usage pattern 2:

RSqlStatement stmt;
TInt err = stmt.Prepare(<database>, <SQL statement>);
while(<condition>)
	{
	err = stmt.Bind<parameter type>(<parameter index>, <value>);
	...
	while((err = stmt.Next()) == KSqlAtRow)
		{
		....
		}
	err = stmt.Reset();
	}
stmt.Close();