Re: [sqlite] Trigger Not working for SELECT criteria

some another solution Please ignor the UPDATE statement but try to focus on my question for Select criteria with 'e2003412DC03011808176518' and 'e006' makes difference. If required i will give my full details of table and trigger. Thanks Ram Mandavkar Igor Tandetnik wrote: > > Ram Man

[sqlite] Re striction on String Length in select criteria

US ) VALUES ('e2003412DC03011808176518',0,'0') If i execute this query it does not work ( UPDATE statement does not get execute ) INSERT INTO READMODE ( EPC,COUNT,STATUS ) VALUES ('e006',0,'0') Is there any restriction on String Length in select criteria as it works for 'e2003412DC03011808176518' an

[sqlite] Trigger Not working for 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'

Re: [sqlite] Between Query failed for DATETIME in sqlite

thanks Jean-Christophe Deschamps i have changed my DT form to /MM/DD hh:mm:ss and all query are working. Jean-Christophe Deschamps wrote: > > >> I am inserting data into asset table as m/d/ HH:MM:SS t format >>Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('12/22/2009 12:01:00

[sqlite] Between Query failed for DATETIME in sqlite

Hello All, I am inserting data into asset table as m/d/ HH:MM:SS t format Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('12/22/2009 12:01:00 AM') Ex: INSERT INTO ASSET (WARRANTSTDATE) VALUES ('9/22/2009 12:01:00 AM') but my select query failed : No record found SELECT * FROM asset where

Re: [sqlite] EPC Based Search

ith EPC as search criteria. > > If you don't want to make it unique at table definition then create an > index on it ('unique' constraint creates an index for you) - it will > speed up any searches on EPC. > > > Pavel > > On Tue, Dec 15, 2009 at 4:54 AM, Simon Davies &g

[sqlite] EPC Based Search

Hello All, I am New to SQL-Lite DB, I had one ASSET table having EPC as varchar(50) field and 5000 records in it. If i want to search ( CREATE TRIGGER "main"."TR_MULTIREAD_BEFORE" BEFORE INSERT ON READMODE BEGIN SELECT CASE WHEN M.a = NEW.EPC THEN