sqlite.getColumnInt

Retrieve the column value for an integer field

sqlite.getColumnInt(queryID, columnNumber)

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

The integer value in that column (for the current row only)

numberStates = sqlite.getColumnInt(compiledQuery, i);

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

• sqlite.getColumn
• sqlite.getColumnCount
• sqlite.getColumnDouble
• sqlite.getColumnName
• sqlite.getColumnText
• sqlite.getColumnType
• sqlite3_column_int API