HTML5 SQLTransaction

- BlackBerry OS 5.0+
- BlackBerry PlayBook
- Ripple Emulator

Permission Elements (PlayBook Only)
This API does not require a <permission> element to be declared in the configuration document of your BlackBerry WebWorks Application.

API Summary

executeSql

---

void executeSql(sqlStatement : String, [arguments: Object[]], [callback: function], [errorCallback: function])

Supported Platform(s)

 - BlackBerry OS 5.0+
 - BlackBerry PlayBook
 - Ripple Emulator

Description

This method executes the provided SQL statement.

Parameter	Type	Description
sqlStatement	String	The SQL statement to be executed on the database.
arguments	Object[] Optional	The optional arguments used to preprocess a SQL statement by binding each ? placeholder with the value of the argument in the arguments array with the same position.
callback	function(transaction : SQLTransaction, resultSet : SQLResultSet) Optional	Function to be called when statement's result set is ready. transaction: The SQLTransaction object that executed this transaction. resultSet: TheSQLResultSet object that contains the results of the SQL statement.
errorCallback	function(transaction : SQLTransaction, error : SQLError) Optional	Function to be called when an SQL error occurs. transaction: The SQLTransaction object that executed this transaction. error: The SQLError object describing the SQL error that occurred.

Code Example(s)

function showDocCount(db, span) {
	db.readTransaction(
		function (t) {
			t.executeSql('SELECT COUNT(*) AS c FROM docids', [], 
				function (t, r) {
					span.textContent = r.rows[0].c;
				}, 
				function (t, e) {
					// couldn't read database
					span.textContent = '(unknown: ' + e.message + ')';
				}
			);
		}
	);
}

Documentation generated by JsDoc Toolkit 2.4.0 on Sun Dec 30 2012 13:31:20 GMT-0500 (EST)