Welcome to WebmasterWorld Guest from 54.226.246.160

Forum Moderators: open

Message Too Old, No Replies

Update The Status Using Trigger Programm

     

salman

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
 

Featured Threads

Hot Threads This Week

Hot Threads This Month