Andrew Arnott wrote:
>
> I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
> too intense for my limited C++ knowledge.
>
If the Windows Phone 8 wrapper for SQLite does not properly set the
temporary
directory, queries that requires a temporary file (e.g. VACUUM) may fail.
Until the wrapper package is changed to do this, the workaround would be to
open a database connection and then immediately execute the following query:
"PRAGMA temp_store_directory = 'C:\some\temp\directory';"
Using the ApplicationData.LocalFolder property for the temporary directory
value should work fine.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
