Project Home
Project Home
Documents
Documents
Wiki
Wiki
Discussion Forums
Discussions
Project Information
Project Info
BroadcastCommunity.qnx.com will be offline from May 31 6:00pm until June 2 12:00AM for upcoming system upgrades. For more information please go to https://community.qnx.com/sf/discussion/do/listPosts/projects.bazaar/discussion.bazaar.topc28418
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