No indices for PRD_DETAILS table. This table does not contain any blobs.
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 on Windows RT/WP8. If required, we can provide the schema for the table containing the BLOB in which images are stored. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, 27 March 2014 1:29 PM 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 On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp <d...@sqlite.org> 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 NOCASE NOT NULL, >> TERID INTEGER NOT NULL, SEQ INTEGER, PRD_DESC TEXT COLLATE NOCASE, >> FRANCHISE_CODE INTEGER, PRD_STATUS TEXT COLLATE NOCASE, PRD_CLASS >> TEXT COLLATE NOCASE, TESTER TEXT COLLATE NOCASE, APN1 TEXT COLLATE >> NOCASE, APN2 TEXT COLLATE NOCASE, APN3 TEXT COLLATE NOCASE, RRP REAL, >> PRD_SIZE INTEGER, EX_GST_ITEM_COST REAL, GST_ITEM_COST REAL, >> ITEM_COST REAL, ORD_QTY INTEGER, NOTES TEXT COLLATE NOCASE, >> ORDERED_QTY INTEGER, PRFLAG1 TEXT COLLATE NOCASE, >> PRFLAG2 TEXT COLLATE NOCASE, PRUSER1 TEXT COLLATE NOCASE, PRUSER2 >> TEXT COLLATE NOCASE, PRSPARE1 TEXT COLLATE NOCASE, PRVAL1 REAL, >> PRVAL2 REAL, BS_USER_ID_ INTEGER, BS_ID_ INTEGER, BS_RTYPE_ INTEGER, >> BS_XTYPE_ INTEGER, BS_XSTATUS_ INTEGER, CONSTRAINT PK_PRD_DETAILS >> PRIMARY KEY (PRD_CODE, >> TERID)) >> >> Let me know if you need anything further. >> > > No indices? > > Also, which columns contain the 1MB blobs? -- 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
