Re: [sqlite] SQLite for Windows Phone bug

2014-02-19 Thread Richard Hipp
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 wrote:

> 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 or missing database . I
> have checked the SQL and that database is well present, but the problem
> persists. The situation is even worse because the inserts and updates that
> fail seem to be completely random - if I compare an entry that fails and
> one that doesn't, there is nothing that should be taken as a reason for the
> error. I'm not the only one experiencing this -
> http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement.
>  The interesting fact is that in the 3.8.1 version this never happened, so
> the cause must be some change between these the version 3.8.1 and version
> 3.8.2.
>
>
> Can you please check if anything can be done? My project is highly
> dependant on SQLite, but this way it is not reliable enough...
>
>
> Thank you very, very much
>
>
> Sincerely
>
>
> Martin Zikmund
>
>
>
>
>
>
> Sent from Surface Pro
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite for Windows Phone bug

2014-02-19 Thread Simon Slavin

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 existing database file or creating a new journal file, or 
the permissions on the database file may be protected against the app.

First make sure you are specifying the correct path.  If you didn't specify a 
full path, try temporarily doing so in your test setup and see if anything 
changes.

If that doesn't work try modifying your app to create a new text file (standard 
C file API) in the same folder as the database file normally lives.  Does it 
succeed ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] SQLite for Windows Phone bug

2014-02-19 Thread Martin Zikmund
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 or missing database . I have 
checked the SQL and that database is well present, but the problem persists. 
The situation is even worse because the inserts and updates that fail seem to 
be completely random - if I compare an entry that fails and one that doesn’t, 
there is nothing that should be taken as a reason for the error. I’m not the 
only one experiencing this - 
http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement
 . The interesting fact is that in the 3.8.1 version this never happened, so 
the cause must be some change between these the version 3.8.1 and version 3.8.2.


Can you please check if anything can be done? My project is highly dependant on 
SQLite, but this way it is not reliable enough…


Thank you very, very much


Sincerely


Martin Zikmund






Sent from Surface Pro
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLITE For Windows phone

2013-08-07 Thread Matthijs ter Woord
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 regarding this
> project, I thank the collaboration
> ___
> 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


[sqlite] SQLITE For Windows phone

2013-08-07 Thread Cadu .
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users