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

2014-03-27 Thread Simon Slavin
On 28 Mar 2014, at 12:58am, Muharrem Bilgin (Bright Software) wrote: > Agreed, and no offence taken :-) The difficulty is to how to get the shell > tool run on Windows RT/Windows Phone 8 ? I wonder if there is any utility > out there based on 3.8.4.1 (or 3.8.4.2 ) that we can use and connect

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On 27 Mar 2014, at 4:00am, Muharrem Bilgin (Bright Software) wrote: > The blob issue mentioned is happening with another table in another > application. The reason it was mentioned because we have the feeling

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

2014-03-27 Thread Richard Hipp
On Thu, Mar 27, 2014 at 7:59 AM, Richard Hipp wrote: > > SQLite 3.8.* is not using the PRIMARY KEY to sort in this case because its > cost function thinks that there is no performance advantage to using the > PRIMARY KEY to sort rather than sorting in a separate step. We might need > to tweak th

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

2014-03-27 Thread Richard Hipp
ction a little to fix this in 3.8.5. Investigating... > > Thanks a lot in advance. > > MB > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin > Sent: Thursday, 27 March 201

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

2014-03-27 Thread Simon Slavin
On 27 Mar 2014, at 4:00am, Muharrem Bilgin (Bright Software) wrote: > The blob issue mentioned is happening with another table in another > application. The reason it was mentioned because we have the feeling that > whenever resulting data reaches to a certain size, SQLITE_ERROR is reported >

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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
Discussion of SQLite Database Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp wrote: > > > > On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bri

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

2014-03-26 Thread Richard Hipp
On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp wrote: > > > > On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bright Software) < > mbil...@brightsoft.com.au> wrote: > >> The table in question is created by using the following statement. >> >> CREATE TABLE PRD_DETAILS (PRD_CODE TEXT COLLATE NOC

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

2014-03-26 Thread Richard Hipp
On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote: > The table in question is created by using the following statement. > > CREATE TABLE PRD_DETAILS (PRD_CODE TEXT COLLATE NOCASE NOT NULL, TERID > INTEGER NOT NULL, SEQ INTEGER, PRD_DESC TEXT COL

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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
ite.org] On Behalf Of Joe Mistachkin > Sent: Thursday, 27 March 2014 11:45 AM > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing > database) onWinRT/ WP8 when querying large (!) result sets using > 3.8.4.1 > > &g

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

2014-03-26 Thread Richard Hipp
7.17, and everything worked fine.) > > Thanks a lot in advance. > > 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:45 AM > To: &#x

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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
ite Database' Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 Muharrem Bilgin wrote: > > Thank you for your input. We are not using the SQLite wrapper. The > sqlite source code is compiled into a

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

2014-03-26 Thread Joe Mistachkin
Muharrem Bilgin wrote: > > 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. > That's fine, setting the temporary directory is always required on WinRT (and Windows Phone 8). > > I ha