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