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
