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. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, 27 March 2014 12:52 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 9:47 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote: > Hi Joe, > > The following are the log entries, which confirm your suspicion (the > log entry format : time, error description, error code). > > As suggested, we are already setting the temp store directory as soon > as a database connection is opened (after sqlite3_open16). Now, the > question is when to use the "PRAGMA temp_store_directory='...';". Do > we have to call it as a specific time ? (i.e. every time before > executing a SELECT statement?) > > 27/03/2014 12:26:50 PM sqlite3_temp_directory variable should be set > for > WinRT,1 > 27/03/2014 12:26:50 PM os_win.c:35713: (0) winGetTempname4() - The > operation completed successfully.,1 > 27/03/2014 12:26:50 PM statement aborts at 40: [SELECT > > PRD_DETAILS.APN1,PRD_DETAILS.APN2,PRD_DETAILS.APN3,PRD_DETAILS.EX_GST_ > ITEM_C > > OST,PRD_DETAILS.FRANCHISE_CODE,PRD_DETAILS.GST_ITEM_COST,PRD_DETAILS.I > TEM_CO > ST,PRD_DETAILS.NOTES,PRD_,1 > Can you send the database schema please? > > (BTW, we temporarily reverted back to 3.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: '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 > > > 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 have tried your suggestion anyway, but no result. > > > > Can you enable the SQLite error logging mechanism, which may provide > more details as to the root cause of the issue? It's described here: > > https://www.sqlite.org/errlog.html > > -- > Joe Mistachkin > > _______________________________________________ > 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 > -- 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
