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

2014-03-11 Thread Andrew Arnott
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

2014-03-11 Thread Joe Mistachkin
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

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

2014-03-11 Thread Andrew Arnott
...@mistachkin.comwrote: 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

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

2014-03-10 Thread Andrew Arnott
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,

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

2014-03-10 Thread Simon Slavin
On 11 Mar 2014, at 12:56am, Andrew Arnott andrewarn...@gmail.com 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-users

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

2014-03-10 Thread Andrew Arnott
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 slav...@bigfraud.org wrote: On 11 Mar 2014, at 12:56am, Andrew Arnott andrewarn...@gmail.com wrote: When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to

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

2014-03-10 Thread Andrew Arnott
I expect I could build a miniature repro if that would be useful to anyone. On Mar 10, 2014 8:05 PM, Andrew Arnott andrewarn...@gmail.com 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 slav...@bigfraud.org

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

2014-03-10 Thread Andrew Arnott
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

2014-03-10 Thread Joe Mistachkin
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 Source=Dart.WinPhone8Lib

[sqlite] SQLite with Windows Phone 8

2013-10-11 Thread Tola Fasoyiro
I am attempting to use SQLite with Windows Phone. I have successfully installed SQLite for Windows and sqlite-net. I get an error in SQLite.cs as follows: type or namespace Community could not be found #if USE_CSHARP_SQLITE using Sqlite3 = Community.CsharpSqlite.Sqlite3; using

Re: [sqlite] SQLite with Windows Phone 8

2013-10-11 Thread Sascha Sertel
Did you add the Community.CsharpSqlite.WinPhone.dll as a dependency to your project? On Fri, Oct 11, 2013 at 5:09 AM, Tola Fasoyiro tola.fasoy...@hotmail.co.ukwrote: I am attempting to use SQLite with Windows Phone. I have successfully installed SQLite for Windows and sqlite-net. I get an

Re: [sqlite] SQLite on Windows Phone 8

2012-11-06 Thread Scott Tiger
Hello Naoh. csharp-sqlite is not a SQLite for Windows Phone 8. Peter is talking about official release of SQLite for Windows Phone 8. http://www.sqlite.org/download.html#wp8 Hello Peter. This also discussed on msdn forum. http://social.msdn.microsoft.com/Forums/en-US/wpdevelop/thread/083fc2a4

Re: [sqlite] SQLite on Windows Phone 8

2012-11-06 Thread Peter Naldal
wrapper including LINQ access works on Windows Phone 8. I uninstalled the official SQLite for Windows Phone 8 extension. I don't understand how to take advantage of it. Tim Heuer writes on his blog, that the purpose is to avoid the hassle of managing different projects for every CPU. I hope to be able

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Peter Naldal
Has anybody tried to install SQLite for Windows Phone 8? Any success? I can install it. It shows up fine under References, but then what? The Object Browser shows nothing. What namespace can I reference? What classes can I use? \Peter Original message

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Joe Mistachkin
Peter Naldal wrote: Original message: ** Topic: [sqlite] SQLite on Windows Phone 8 Hi Visual Studio 2012 for Windows Phone offers installation of SQLite for Windows Phone 8 as an extension. To enable programming against this extension a wrapper

Re: [sqlite] SQLite on Windows Phone 8

2012-11-05 Thread Noah Hart
: This is not an official version of SQLite There is completely NO affiliation with SQLite.org Bugs should not be reported to their ticket tracking system Thank you, Noah Hart -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p65382.html Sent from

[sqlite] SQLite on Windows Phone 8

2012-11-02 Thread Peter Naldal
Hi Visual Studio 2012 for Windows Phone offers installation of SQLite for Windows Phone 8 as an extension. To enable programming against this extension a wrapper component or library needs to be installed. I am using sqlite-net installed via NuGet. But when compiling SQLite.cs, the compiler

Re: [sqlite] SQLite on Windows Phone 8

2012-11-02 Thread Joe Mistachkin
Peter Naldal wrote: Visual Studio 2012 for Windows Phone offers installation of SQLite for Windows Phone 8 as an extension. To enable programming against this extension a wrapper component or library needs to be installed. I am using sqlite-net installed via NuGet. When using the SQLite