vendredi 11 décembre 2015

sqlite trigger in if else statement

CREATE  TRIGGER "main"."after_update_roomkey" AFTER UPDATE ON "ROOMKEY"
 BEGIN 

if (roomID=new.roomID)

 update room set status='Available' where roomID=new.roomID;

else(roomID=old.roomID)
 update room set status='Non Available' where roomID=new.roomID;

 END


CREATE TABLE ROOM ( 
    roomID VARCHAR(10) PRIMARY KEY, 
    numOfBed INTEGER, 
    roomFloor VARCHAR(5),
    status VARCHAR(20),
    categoryID VARCHAR(10),
    FOREIGN KEY (categoryID) REFERENCES ROOMCATEGORY(categoryID)
)

CREATE TABLE "ROOMCATEGORY" 
("categoryID" VARCHAR(10) PRIMARY KEY  NOT NULL ,
"typesOfRoom" VARCHAR(50) NOT NULL  DEFAULT (null) ,
"price" DOUBLE(10,2) NOT NULL )

I'm no expert in sqlite. Please help me solve this sqlite trigger in IF ELS statement.

Aucun commentaire:

Enregistrer un commentaire