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 1.0+

- BlackBerry 10

- Ripple Emulator

View Supported Platform Table

API	BB5.0	BB6.0	BB7.0	PB1.0	PB2.0	BB10	Ripple
insertId	Y	Y	Y	Y	Y	Y	Y
rows	Y	Y	Y	Y	Y	Y	Y
rowsAffected	Y	Y	Y	Y	Y	Y	Y

Configuration Document Settings

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 and BlackBerry 10+)
This API does not require a <permission> element to be declared in the configuration document of your BlackBerry WebWorks Application.

Properties

Number	insertId
SQLResultSetRowList	rows
Number	rowsAffected

Properties

readonly Number insertId

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.

Supported Platforms
	- BlackBerry OS 5.0+
	- BlackBerry PlayBook 1.0+
	- BlackBerry 10
	- Ripple Emulator

readonly SQLResultSetRowList rows

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).

Supported Platforms
	- BlackBerry OS 5.0+
	- BlackBerry PlayBook 1.0+
	- BlackBerry 10
	- Ripple Emulator

readonly Number rowsAffected

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.

Supported Platforms
	- BlackBerry OS 5.0+
	- BlackBerry PlayBook 1.0+
	- BlackBerry 10
	- Ripple Emulator

Documentation generated by JsDoc Toolkit 2.4.0 on Sun Dec 30 2012 18:15:44 GMT-0500 (EST)