void bindBlobParameter ( PRUint32 paramIndex , arrayof PRUint8 value , PRUint32 valueSize )

Arguments:

paramIndex

value

valueSize

void bindDoubleParameter ( PRUint32 paramIndex , double value )

Arguments:

paramIndex

value

void bindInt32Parameter ( PRUint32 paramIndex , PRInt32 value )

Arguments:

paramIndex

value

void bindInt64Parameter ( PRUint32 paramIndex , PRInt64 value )

Arguments:

paramIndex

value

void bindNullParameter ( PRUint32 paramIndex )

Arguments:

paramIndex

void bindStringParameter ( PRUint32 paramIndex , AString value )

Arguments:

paramIndex

value

void bindUTF8StringParameter ( PRUint32 paramIndex , AUTF8String value )

Bind the given value to the parameter at paramIndex. Index 0 denotes the first numbered argument or ?1.

Arguments:

paramIndex

value

mozIStorageStatement clone ( )

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.

AString escapeStringForLIKE ( AString value , PRUnichar escapeChar )

Escape a string for SQL LIKE search.

Arguments:

value: the string to escape for SQL LIKE

escapeChar: the escape character

void execute ( )

Execute the query, ignoring any results. This is accomplished by calling step() once, and then calling reset().

Error and last insert info, etc. are available from the mozStorageConnection.

PRBool executeStep ( )

Execute a query, using any currently-bound parameters. Reset must be called on the statement after the last call of executeStep.

void finalize ( )

Finalizes a statement so you can successfully close a database connection. This method does not need to be used from native callers since you can just set the statement to null, but is extremely useful to JS callers.

AUTF8String getColumnDecltype ( PRUint32 paramIndex )

Obtains the declared column type of a prepared statement.

Arguments:

paramIndex: The zero-based index of the column who's declared type we are interested in.

PRUint32 getColumnIndex ( AUTF8String name )

Obtains the index of the column with the specified name.

Arguments:

name: The name of the column.

Returns:

The index of the column with the specified name.

AUTF8String getColumnName ( PRUint32 columnIndex )

Name of nth column

Arguments:

columnIndex

[notxpcom] sqlite3stmtptr* getNativeStatementPointer ( )

PRUint32 getParameterIndex ( AUTF8String name )

Returns the index of the named parameter.

Arguments:

name: The name of the parameter you want the index for.

Returns:

The index of the named parameter.

AUTF8String getParameterName ( PRUint32 paramIndex )

Name of nth parameter, if given

Arguments:

paramIndex

void initialize ( mozIStorageConnection DBConnection , AUTF8String SQLStatement )

Initialize this query with the given SQL statement.

Arguments:

DBConnection

SQLStatement

void reset ( )

Reset parameters/statement execution