Welcome to WebmasterWorld Guest from 54.145.174.178

Forum Moderators: open

Message Too Old, No Replies

Update The Status Using Trigger Programm

   
11:53 am on Jun 20, 2012 (gmt 0)



(code, sub_namesub_passMarks, sub_internalPassmarks)
(101, English, 32, 12)


(Roll_No, 101, 101_nt)
(24514, 35, 8)



(Roll_No,Backlock Status)


i have two tables first one is subject table and second one is student table..i want o write a trigger to generate "backlickStatus"
like

the student table field compare with the subject table code and check whether the student marks are greater than then update status as pass
other wise fail in "back-lock status"(it another table status)
PRIMARY KEYS-CODE,ROLL_NO

THANK YOU IN ADVANCE