Hi Joe, Thanks for the workaround. It works!
Is there a place where a bug should be filed to track this? -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your right to say it." - S. G. Tallentyre On Tue, Mar 11, 2014 at 3:30 PM, Joe Mistachkin <sql...@mistachkin.com>wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users