2010/1/22 Tiberio, Sylvain <[email protected]>: > Hi, > > Here is my database: > . . . > CREATE TRIGGER range_del BEFORE DELETE ON range FOR EACH ROW > BEGIN > SELECT RAISE(FAIL,'Room exist in this range') > WHERE (SELECT count(*) > FROM room > WHERE room.roomId BETWEEN OLD.roomIdMin AND OLD.roomIdMax)= 0; > END;
Try "WHERE room.roomId BETWEEN OLD.roomIdMin AND OLD.roomIdMax)!= 0;" Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
