On Tue, Dec 07, 2010 at 06:08:28PM -0200, Horacio Rabelo Pereira scratched on
the wall:
> Searching in the Web, I found a note describing a workaround, that
> consist in change the pragma ???jornal_mode??? to value ???truncate???.
>
> For my surprise, all my tries to change the value of pragma
> ???journal_mode??? don't work. I try change
> via SQL DDL script, via SQL Expert and via application.
This PRAGMA is a property of the active database connection, not the
database file. You need to re-set it every time you call
sqlite3_open_v2().
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
