sqlite.getColumn

Retrieve the value of the specified column element

sqlite.getColumn(queryID, columnNumber)

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

The value for that column element. This function is reasonable “smart” in that it doesn’t care what the data type for the column is, it’ll return whatever data type there is into a Frontier variable. You’re more likely to use this function than the various sqlite.getColumnXXXX typed functions.

value = sqlite.getColumn(compiledQuery, i);

Remember that the first column is 1 in the Frontier routine sqlite.getColumn.

• sqlite.getColumnCount
• sqlite.getColumnDouble
• sqlite.getColumnInt
• sqlite.getColumnName
• sqlite.getColumnText
• sqlite.getColumnType