Re: [sqlite] Trigger Not working for SELECT criteria

Ram Mandavkar wrote: > But my question is related to select criteria > Is there any restriction on String Length in select criteria > as it works for 'e2003412DC03011808176518' and same query does not work for > 'e006' > FOR TRIGGERS I cannot reproduce this particular issue. In my tests, your

Re: [sqlite] Trigger Not working for SELECT criteria

Hello, Thanks for reply. I always get help/correct solution from this nibble forum. But my question is related to select criteria Is there any restriction on String Length in select criteria as it works for 'e2003412DC03011808176518' and same query does not work for 'e006' FOR TRIGGERS

Re: [sqlite] [bug+patch] Old lemon bug reintroduced

On Jan 6, 2010, at 7:50 PM, D. Richard Hipp wrote: > > On Jan 6, 2010, at 7:47 PM, Wilson, Ronald wrote: > >> Does check-in [077a6bee2d] resolve the issue below? >> >> http://www.sqlite.org/src/vinfo/077a6bee2d >> > > > Yes. I didn't realize the issue had a ticket. I'll close it. Silly me - I

Re: [sqlite] [bug+patch] Old lemon bug reintroduced

On Jan 6, 2010, at 7:47 PM, Wilson, Ronald wrote: > Does check-in [077a6bee2d] resolve the issue below? > > http://www.sqlite.org/src/vinfo/077a6bee2d > Yes. I didn't realize the issue had a ticket. I'll close it. D. Richard Hipp d...@hwaci.com

Re: [sqlite] [bug+patch] Old lemon bug reintroduced

Does check-in [077a6bee2d] resolve the issue below? http://www.sqlite.org/src/vinfo/077a6bee2d Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) > -Original

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

Doyel5 wrote: > I have a 800MB MS Access database that I migrated to SQLite. The > structure of the database is as follows (the SQLite database, after > migration, is around 330MB): > > The table ‘Occurrence’ has 1,600,000 records. The table looks like: > CREATE TABLE

Re: [sqlite] SQlite query performs 10 times slower than MS Access query

Why you change the query? Use de Access version or someone without joining a subquery. Is preferible to join table to table (to more tables) than join table to subqueries. Emilio Doyel5 escribió: > I have a 800MB MS Access database that I migrated to SQLite. The structure of > the database is

[sqlite] SQlite query performs 10 times slower than MS Access query

I have a 800MB MS Access database that I migrated to SQLite. The structure of the database is as follows (the SQLite database, after migration, is around 330MB): The table ‘Occurrence’ has 1,600,000 records. The table looks like: CREATE TABLE Occurrence ( SimulationID INTEGER,SimRunID

Re: [sqlite] SQLITE_ERROR with system usage

On Jan 6, 2010, at 11:11 AM, Christopher Sansone wrote: > > repeat > sqlite3_prepare(db, sql, -1, p, sql); > repeat Try inserting a call to sqlite3_reset(p) here >s := sqlite3_step(p); > until >s in (SQLITE_DONE, SQLITE_ERROR, SQLITE_MISUSE); > sqlite3_finalize(p); > until > sql is

Re: [sqlite] SQLITE_ERROR with system usage

Have you run a memory test on your system? Random failings when working hard is a classic symptom of dodgy memory (launching Firefox may cause memory to be allocated for SQLite elsewhere than when there's nothing else running). I once had a system that would segfault in the C compiler in

Re: [sqlite] SQLITE_ERROR with system usage

On 6 Jan 2010, at 4:11pm, Christopher Sansone wrote: > The error specifically occurs in sqlite3_step(). You did say in your post SQLITE_ERROR. Can you get the extended error message for us or any other routine that might give more detail than that ? > Does anyone have any ideas of why this

[sqlite] SQLITE_ERROR with system usage

Hi everyone, I'm hoping someone can help with a strange issue I'm having. I have a SQLite application that runs a some modest SQL scripts (~750KB) to create and populate a database. For the same exact script, sometimes it works perfectly and other times it fails with a SQLITE_ERROR. When it

[sqlite] Re striction on String Length in select criteria

Hello All, // -- ReadMode Table // --- // CREATE TABLE "READMODE" ("EPC" VARCHAR(50) COLLATE NOCASE ,"COUNT" INTEGER,"STATUS" VARCHAR) With 2 records 'e006',0,'0' 'e2003412DC03011808176518',0,'0'