sqlite.getRowColumnNames

Retrieve an entire row in an SQLite query

sqlite.getRowColumnNames(queryID)

queryID is the query ID returned by sqlite.compileQuery.

A Frontier list containing the names of the columns as a result of the query.

on rowNameTest () {
	local (db, result, compiledQuery, rowcount=0, i, columnType, columnCount);
	local (columnName, value, columnTypeString, rowList, dataset="");
	db = sqlite.open("C:\\temp\\testdatabase.db3");
	compiledQuery = sqlite.compileQuery(db, "select * from verbs");
	result = sqlite.stepQuery(compiledQuery);
	rowList = sqlite.getRowColumnNames(compiledQuery);
	sqlite.clearQuery(compiledQuery);
	dialog.alert(rowList);
	result = sqlite.close(db)}

The output is a list of names. Remember: queries don’t always return all the rows in a table. This is the best way to determine the names of the actual columns returned.

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