Welcome to WebmasterWorld Guest from 54.196.188.52

Forum Moderators: open

Message Too Old, No Replies

Update The Status Using Trigger Programm

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

New User

joined:June 12, 2012
posts: 7
votes: 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
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members