sqlite.clearQuery

Clear an SQLite query from memory

sqlite.clearQuery(queryID)

queryID is the query ID returned by sqlite.compileQuery.

An SQLite result code.

on createTable () {
	local (db, query, compiledQuery);
	db = sqlite.open("C:\\temp\\testdatabase.db3");
	bundle { // the create table query
		query = "CREATE TABLE [verbs] (" + cr;
		query = query + "  [ID] INTEGER," + cr;
		query = query + "  [category] TEXT COLLATE NOCASE," + cr;
		query = query + "  [verbname] TEXT COLLATE NOCASE)" + cr};
	compiledQuery = sqlite.compileQuery(db, query);
	result = sqlite.stepQuery(compiledQuery);
	result = sqlite.clearQuery(compiledQuery);
	sqlite.close(db)}

sqlite.clearQuery is different from sqlite.resetQuery. sqlite.clearQuery removes the query from memory, while sqlite.resetQuery does what it says: it resets the query, still in memory, so when you execute your next sqlite.stepQuery, you start from the top once again.

• sqlite.compileQuery
• sqlite.easyQuery
• sqlite.escapeQuotes
• sqlite.getRow
• sqlite.getRowColumnNames
• sqlite.resetQuery
• sqlite.stepQuery
• sqlite3_finalize API