Richard The first workaround "FROM PRD_DETAILS INDEXED BY sqlite_autoindex_PRD_DETAILS_1" worked.
However the second work around " PRAGMA temp_store=MEMORY;" did not help resolve the issue, even though it is executed with no errors. Thank you for your help, MB -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, 27 March 2014 11:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on Win RT/ WP8 when querying large (!) result sets using 3.8.4.1 On Wed, Mar 26, 2014 at 8:13 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote: > > FROM PRD_DETAILS > > As a work-around, please try changing this line of your query to read: FROM PRD_DETAILS INDEXED BY sqlite_autoindex_PRD_DETAILS_1 At the same time, you really should try to figure out why you cannot create temporary files on the phone. Another work-around would be to turn off all temporary files using PRAGMA temp_store=MEMORY; That might require more memory, though. -- D. Richard Hipp d...@sqlite.org _______________________________________________ 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
