Cursor Instance Properties

The properties of Cursor objects vary from instance to instance. Each Cursor object has a property for each named column in the Cursor. Thus, when a Cursor is created, it acquires a property for each column in the virtual table, as determined by the SELECT statement.

Note - Unlike other properties in JavaScript, cursor properties corresponding to column names are not case sensitive, because SQL is not case sensitive and some databases are not case sensitive.

Properties of a Cursor object can be referred to as elements of an array. The 0-index array element corresponds to the first column, the 1-index array element corresponds to the second column, and so on.

SELECT statements can retrieve values that are not columns in the database, such as aggregate values and SQL expressions. Display these values by using the Cursor's property array index for the value.

Cursor filter

Cursor sort