Apologies if this topic has been discussed before ... I just came across a surprising behaviour when executing this command: PRAGMA journal_mode=<something>;
I would have expected that sqlite3_step() will return SQLITE_DONE with this command, as is the case with (AFAIK) any other PRAGMA command that assigns a value, i.e. a "=" is contained. However, SQLITE_ROW ist returned instead because the command not only sets the new value but also returns the current (?) one. Is this behaviour intended? It can bee watched in the CLI also. Wolfgang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users