class SQLResult

A container for results obtained in an SQLite.exec() call.

Not every SQLite.exec() call will produce results, but any database query (SELECT in particular) will generate an SQLResult object even if the result is empty.

SQLResult is not yet supported in the v8 engine.

Constructors

new SQLResult();

Constructs a new instance of the SQLResult class

Methods

fieldname

Get the fieldname of a column at a given index

fieldname(index: number): string;

numfields

Get the number of fields in the dataset returned in the SQLResult object

numfields(): number;

numrecords

Get the number of records were returned in the SQLResult object

numrecords(): number;

value

Get the value of a record at a column index and record number

value(index: number, record_no: number): number | string;

Example

function print_everything(sqlres) {
    var numrecs = sqlres.numrecords()
    var numflds = sqlres.numfields()

    var field_names = new Array()
    for (var i = 0; i < numflds; i++) {
        field_names[i] = sqlres.fieldname(i)
    }

    for (var i = 0; i < numrecs; i++) {
        for (var j = 0; j < numflds; j++) {
            post(
                "Rec: ",
                i,
                " field ",
                field_names[j],
                " value ",
                sqlres.value(j, i),
                "\n"
            )
        }
    }
}