On Thu, Jul 26, 2012 at 4:32 PM, Arbol One <arbol...@gmail.com> wrote: > Reading the documentation, it says that 'sqlite3_step(sqlite3_stmt*) > > ' must be called at least once to evaluate the statement. However, what does > it evaluate?
The prepared statement. Prepared statements are really a byte-compiled form of your statement. sqlite3_step() runs the virtual machine with the given prepared statement until one row is output or the prepared statement terminates. You should call sqlite3_step() in a loop in general, to ensure that you consume all output rows (if you care about them). CREATE, ALTER, DROP, INSERT, UPDATE, and DELETE statements run to completion in one call to sqlite3_step(), and so do many (but not all) PRAGMAs. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users