Project Home
Project Home
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
Forum Topic - qdb: problem with triggers: (1 Item)
   
qdb: problem with triggers  
Hello. I have encountered following problem: when i trying to create simple trigger like that

CREATE TRIGGER a1 BEFORE INSERT ON t1 FOR EACH ROW
BEGIN
	SELECT * FROM t1;  -- no matter what action trigger performs
END;

qdbc says: "qdbc: unable to execute - near ";": syntax error". 

Table t1 exists, select query works fine.
My OS is QNX 6.5.0. 

I'm not the one who had got the same problem, this man got the same: http://sqlite.1065341.n5.nabble.com/Create-trigger-
td14987.html

What is the problem can be?

Thanks a lot
Alexey Zateev