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.

Index

Constructors

• new SQLResult()

Methods

• fieldname(index)
• numfields()
• numrecords()
• value(index, record_no)

new SQLResult()

new SQLResult();

Constructs a new instance of the SQLResult class

fieldname(index)

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(index, record_no)

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",
      );
    }
  }
}