HTML5 SQLResultSet

The SQLResultSet object is generated as a result of executing an SQL Transaction. See executeSql.

Supported Platform(s)

- BlackBerry OS 5.0+
- BlackBerry PlayBook
- Ripple Emulator

API	OS 5.0	OS 6.0	OS 7.0	PlayBook	Ripple
insertId	Y	Y	Y	Y	Y
rows	Y	Y	Y	Y	Y
rowsAffected	Y	Y	Y	Y	Y

To use all of the API described for this object, you must ensure the following settings are in your configuration document:

This API does not require a <feature> element to be declared in the configuration document of your BlackBerry WebWorks Application.

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

Property	Type	Description	Supported Platform(s)
insertId	Number readonly	If the SQL statement inserted a row, this attribute returns the row ID of the row that the SQLResultSet object's SQL statement inserted into the database. If the SQL statement inserted multiple rows, this attribute returns the the ID of the last row.	- BlackBerry OS 5.0+ - BlackBerry PlayBook - Ripple Emulator
rows	SQLResultSetRowList readonly	This attribute represents the rows returned in the order returned by the database.If no rows were returned, then the object will be empty (its length will be zero).	- BlackBerry OS 5.0+ - BlackBerry PlayBook - Ripple Emulator
rowsAffected	Number readonly	This attribute returns the number of rows that were changed by the SQL statement. If the statement did not affected any rows, 0 is returned.	- BlackBerry OS 5.0+ - BlackBerry PlayBook - Ripple Emulator

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