Re: [sqlite] Trigger Not working for SELECT criteria

2010-01-06 Thread Igor Tandetnik
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

2010-01-06 Thread Ram Mandavkar
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] Trigger Not working for SELECT criteria

2010-01-05 Thread Igor Tandetnik
Ram Mandavkar wrote: > CREATE TABLE "READMODE" ("EPC" VARCHAR(50) COLLATE NOCASE ,"COUNT" > INTEGER,"STATUS" VARCHAR) > With 2 records > 'e006',0,'0' > 'e2003412DC03011808176518',0,'0' > > // > -- > Trigger on

[sqlite] Trigger Not working for SELECT criteria

2010-01-05 Thread Ram Mandavkar
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'