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'
Can any one help me to understand what/where is the problem in select
trigger .
--
View this message in context:
http://old.nabble.com/Trigger-Not-working-for-SELECT-criteria-tp27025539p27025539.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
