sqlite.getColumnText

Retrieve the column value for a text field

sqlite.getColumnText(queryID, columnNumber)

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

A string containing the text value in that column (for the current row only)

s = sqlite.getColumnText(compiledQuery, i);

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

• sqlite.getColumn
• sqlite.getColumnCount
• sqlite.getColumnDouble
• sqlite.getColumnInt
• sqlite.getColumnName
• sqlite.getColumnType
• sqlite3_column_text API