Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Muharrem Bilgin (Bright Software)
ase' 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: > > Hi Joe, > Answers below. > > Is the directory obtained via the > Windows::Storage::ApplicationData::Current->Lo

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
Muharrem Bilgin wrote: > > Hi Joe, > Answers below. > > Is the directory obtained via the > Windows::Storage::ApplicationData::Current->LocalFolder->Path property? > > Yes > > What SQLite warning/error log entries are you seeing when you set the > temporary directory to the LocalState

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Muharrem Bilgin (Bright Software)
Hi Joe, Answers below. Is the directory obtained via the Windows::Storage::ApplicationData::Current->LocalFolder->Path property? > Yes What SQLite warning/error log entries are you seeing when you set the temporary directory to the LocalState directory? > Nothing. sqlite returns success

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-27 Thread Joe Mistachkin
Muharrem Bilgin wrote: > > Yes to both questions (we are checking the result and it is returning > SQLITE_OK, and we are passing a UTF-16 string). > Is the directory obtained via the Windows::Storage::ApplicationData::Current->LocalFolder->Path property? What SQLite warning/error log entries

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Muharrem Bilgin (Bright Software)
[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

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

2014-03-26 Thread Joe Mistachkin
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