Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

Hi Joe, Thanks for your reply. After making that change (and also adding the SQLite3.SetDirectory method definition itself since that too was inside an #if) the app crashes because WP8 doesn't support the TemporaryFolder property. 'Windows.Storage.ApplicationData.Current.TemporaryFolder' threw

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

Andrew Arnott wrote: > > The exception raised when I send "VACUUM" as a sql statement is: > SQLite.SQLiteException occurred > _HResult=-2146233088 > _message=SQL logic error or missing database > HResult=-2146233088 > Message=SQL logic error or missing database >

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

I've created a trivial repro project, which you can download here: http://1drv.ms/N2D4gP The exception raised when I send "VACUUM" as a sql statement is: SQLite.SQLiteException occurred _HResult=-2146233088 _message=SQL logic error or missing database HResult=-2146233088 Message=SQL logic

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

I expect I could build a miniature repro if that would be useful to anyone. On Mar 10, 2014 8:05 PM, "Andrew Arnott" wrote: > It raises an error, which the sqlite.cs file that everyone uses turns into > an exception. > On Mar 10, 2014 6:01 PM, "Simon Slavin"

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

It raises an error, which the sqlite.cs file that everyone uses turns into an exception. On Mar 10, 2014 6:01 PM, "Simon Slavin" wrote: > > On 11 Mar 2014, at 12:56am, Andrew Arnott wrote: > > > When I upgraded from the SQLite for WinPhone8 SDK

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

On 11 Mar 2014, at 12:56am, Andrew Arnott wrote: > When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the > VACUUM statement quit working. Any idea why? What does it do instead of work ? Simon. ___

[sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the VACUUM statement quit working. Any idea why? I'd be quite happy to 'rollback' to 3.8.1, but I can't find a way to download prior versions of the SDK. Thanks. -- Andrew Arnott "I [may] not agree with what you have to say,