sqlite.getColumnCount

Retrieve the number of columns returned from an SQLite query.

sqlite.getColumnCount(queryID)

queryID is the query ID returned by sqlite.compileQuery.

The number of columns in the result set returned by the prepared SQL statement

on getRowColumnNames (queryID) {
	local (i, count, resultList={});
	count = sqlite.getColumnCount(queryID);
	for i = 1 to count {
		resultList[i] = sqlite.getColumnName(queryID, i)};
	return resultList}

Returns 0 the query is an SQL statement that does not return data (for example an UPDATE).

• sqlite.getColumn
• sqlite.getColumnDouble
• sqlite.getColumnInt
• sqlite.getColumnName
• sqlite.getColumnText
• sqlite.getColumnType
• sqlite3_column_count API