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'
//
--------------------------------------------------------------------------------------
Trigger on ReadMode Table
// --------------- //
CREATE TRIGGER "main"."TR_MULTIREAD_AFTER" AFTER INSERT ON READMODE
WHEN( SELECT EPC AS a FROM READMODE where EPC=NEW.EPC AND COUNT=0
collate nocase )
BEGIN
UPDATE READMODE SET STATUS='1';
END
//
--------------------------------------------------------------------------------------
If i execute this query it works fine
INSERT INTO READMODE ( EPC,COUNT,STATUS ) 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' and same query does not work for
'e006'
Thanks
Ram Mandavkar
--
View this message in context:
http://old.nabble.com/Restriction-on-String-Length-in-select-criteria-tp27026834p27026834.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
