Re: [sqlite] SQLite in Windows Phone Runtime Component

Arne Fischer wrote: > > { "AreFileApisANSI", (SYSCALL)AreFileApisANSI, 0 }, > > And the Error is: > Error 2 error C2065: 'AreFileApisANSI' : undeclared identifier > In order to compile SQLite for Windows Phone 8, the following extra de

[sqlite] SQLite in Windows Phone Runtime Component

I want to use native c++ code within my WindowsPhone 8 Application. For this purpose I did build a "Windows Phone Runtime Component" to wrap my c++ code. I simply compile my native code with visual studio when I compile the Runtime Component. This took some tweaking but Visual Studio is now

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

chkin <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 se

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.

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,

Re: [sqlite] SQLite for Windows Phone bug

Have you activated the error and warning log to see if it gives you any further diagnostics? http://www.sqlite.org/errlog.html On Wed, Feb 19, 2014 at 12:06 AM, Martin Zikmund <martinzikm...@live.com>wrote: > Hello, SQLite team, > > > I would like to report a bug in the Win

Re: [sqlite] SQLite for Windows Phone bug

On 19 Feb 2014, at 5:06am, Martin Zikmund wrote: > SQL logic error or missing database The two usual causes of this under WinMob are both related to permissions and privileges. The folder the database file is stored in may be protected against the app opening the

[sqlite] SQLite for Windows Phone bug

Hello, SQLite team, I would like to report a bug in the Windows Phone version of SQLite, that is already present for three releases in the row. The problem arises quite randomly, when SQLite refuses to insert or update some items into database and throws the following error: SQL logic error

Re: [sqlite] SQLite with Windows Phone 8

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.uk>wrote: > > I am attempting to use SQLite with Windows Phone. I have successfully > installed SQLite for Windows and sq

[sqlite] SQLite with Windows Phone 8

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.Sqli

Re: [sqlite] SQLITE For Windows phone

See http://developer.nokia.com/Community/Wiki/How_to_use_SQLite_in_Windows_Phone On Wed, Aug 7, 2013 at 2:23 AM, Cadu . wrote: > Hello I wonder if you could send me a tutorial on how to add the SQLITE > project in Visual Studio 2012, since not found any material

[sqlite] SQLITE For Windows phone

Hello I wonder if you could send me a tutorial on how to add the SQLITE project in Visual Studio 2012, since not found any material regarding this project, I thank the collaboration ___ sqlite-users mailing list

Re: [sqlite] SQLite on Windows Phone 8

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 CP

Re: [sqlite] SQLite on Windows Phone 8

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

: 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

Re: [sqlite] SQLite on Windows Phone 8

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 en

Re: [sqlite] SQLite on Windows Phone 8

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 Origin

Re: [sqlite] SQLite on Windows Phone 8

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

[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 component or library needs to be installed. I am using sqlite-net installed via NuGet. But when