sqlite.getColumnName

Retrieve the name of a column

sqlite.getColumnName(queryID, columnNumber)

queryID is the query ID returned by sqlite.compileQuery. columnNumber is the number of the column.

A string containing the name of the column

compiledQuery = sqlite.compileQuery(db, "select * from cities");
result = sqlite.stepQuery(compiledQuery);
columnCount = sqlite.getColumnCount(compiledQuery);
dialog.alert(columnCount);
for i = 1 to columnCount {
	result = sqlite.getColumn(compiledQuery, i);
	columnName = sqlite.getColumnName(compiledQuery, i);
	columnType = sqlite.getColumnType(compiledQuery, i);
	dialog.alert(i + ": name=" + columnName + " type=" + columnType);

Remember that the first column is 1 in the Frontier routine sqlite.getColumnName but is a 0 in the original SQLite sqlite3_column_name function.

• sqlite.getColumn
• sqlite.getColumnCount
• sqlite.getColumnDouble
• sqlite.getColumnInt
• sqlite.getColumnText
• sqlite.getColumnType
• sqlite3_column_name API