sqlite.getRow

Retrieve an entire row in an SQLite query

sqlite.getRow(queryID)

queryID is the query ID returned by sqlite.compileQuery.

A Frontier list containing the results of the query. The list returned contains one element corresponding to each returned column element in the query.

on easyQuery (dbID, queryString, maxRows=0) {
	local (compiledQuery, dataset={}, row, rowCount=0);
	compiledQuery = sqlite.compileQuery(dbID, queryString);
	loop {
		result = sqlite.stepQuery(compiledQuery);
		if result != 100 { // SQLite's code for more rows
			break};
		++rowCount;
		if (maxRows > 0) and (rowCount > maxRows) {
			break};
		row = sqlite.getRow(compiledQuery);
		dataset[rowCount] = row};
	sqlite.clearQuery(compiledQuery);
	return dataset}

The above example is the script code for the sqlite.easyQuery function. As you can see, it iterates through the returned rows, building up a list of results.

• sqlite.clearQuery
• sqlite.compileQuery
• sqlite.easyQuery
• sqlite.escapeQuotes
• sqlite.getRowColumnNames
• sqlite.resetQuery
• sqlite.stepQuery