A SQL statement that can be used for both synchronous and asynchronous
purposes.
Create a clone of this statement, by initializing a new statement
with the same connection and same SQL statement as this one. It
does not preserve statement state; that is, if a statement is
being executed when it is cloned, the new statement will not be
executing.
Name of nth parameter, if given
Returns the index of the named parameter.
| aName | The name of the parameter you want the index for. This does not include the leading ':'. |
| the index of the named parameter. |
Name of nth column
Obtains the index of the column with the specified name.
| aName | The name of the column. |
| The index of the column with the specified name. |
Obtains the declared column type of a prepared statement.
| aParamIndex | The zero-based index of the column who's declared type we are interested in. |
| the declared index type. |
Reset parameters/statement execution
Execute the query, ignoring any results. This is accomplished by
calling executeStep() once, and then calling reset().
Error and last insert info, etc. are available from
the mozStorageConnection.
Execute a query, using any currently-bound parameters. Reset
must be called on the statement after the last call of
executeStep.
| a boolean indicating whether there are more rows or not; row data may be accessed using mozIStorageValueArray methods on the statement. |
Indicate the data type of the current result row for the the given column.
SQLite will perform type conversion if you ask for a value as a different
type than it is stored as.
| aIndex | 0-based column index. |
| The type of the value at the given column index; one of VALUE_TYPE_NULL, VALUE_TYPE_INTEGER, VALUE_TYPE_FLOAT, VALUE_TYPE_TEXT, VALUE_TYPE_BLOB. |
Retrieve the contents of a column from the current result row as an
integer.
| aIndex | 0-based colummn index. |
| Column value interpreted as an integer per type conversion rules. @{ |
@} */
Retrieve the contents of a column from the current result row as a
floating point double.
| aIndex | 0-based colummn index. |
| Column value interpreted as a double per type conversion rules. |
Retrieve the contents of a column from the current result row as a
string.
| aIndex | 0-based colummn index. |
| The value for the result column interpreted as a string. If the stored value was NULL, you will get an empty string with IsVoid set to distinguish it from an explicitly set empty string. @{ |
@} */
Retrieve the contents of a column from the current result row as a
blob.
| aIndex | 0-based colummn index. |
| [out] | aDataSize The number of bytes in the blob. |
| [out] | aData The contents of the BLOB. This will be NULL if aDataSize == 0. |
Check whether the given column in the current result row is NULL.
| aIndex | 0-based colummn index. |
| true if the value for the result column is null. |
Returns a shared string pointer
Number of columns returned
The number of entries in the array (each corresponding to a column in the
database row)
Execute a query, using any currently-bound parameters. Reset is called
when no more data is returned. This method is only available to JavaScript
consumers.
@deprecated As of Mozilla 1.9.2 in favor of executeStep().
@return a boolean indicating whether there are more rows or not.
[deprecated] boolean step();
Obtains the current list of named parameters, which are settable. This
property is only available to JavaScript consumers.
readonly attribute mozIStorageStatementParams params;
Obtains the current row, with access to all the data members by name. This
property is only available to JavaScript consumers.
readonly attribute mozIStorageStatementRow row;
These type values are returned by getTypeOfIndex
to indicate what type of value is present at
a given column.