Hi Joe,

Thank you for your input. We are not using the SQLite wrapper. The sqlite
source code is compiled into a Windows Store/Phone DLL and used in our
application.

I have tried your suggestion anyway, but no result.

MB.


-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Thursday, 27 March 2014 11:17 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on
WinRT/ WP8 when querying large (!) result sets using 3.8.4.1


Muharrem Bilgin wrote:
> 
> We are trying to query a table with 7011 records (simply first calling
> sqlite3_prepare16_v2 and then sqlite3_step, nothing complicated that is).
It
> appears sqlite3_step returns SQLITE_ERROR if result sets contain 
> records more than a certain size. The very 3.8.4.1 version on Windows 
> desktop appears to work ok with the same data set. It successfully 
> returns relatively larger number of records.
> 

If the WinRT/WinPhone8 wrapper for SQLite does not properly set the
temporary directory, queries that requires a temporary file 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

Reply via email to