Trigger Help

• ANIL MAHADEV

  Old Hand

  Points: 345

  More actions

  May 24, 2004 at 12:48 am

  #152155

  I need to create a trigger Remark_trig, that should b provoked when my data is inserted in a table called issue_details.

  The function of the trigger should insert details of the students in the Remarks Field.

  Thank You

  Anil Mahadev

• roberthamilton

  Ten Centuries

  Points: 1002

  More actions

  May 24, 2004 at 5:19 am

  #507444

  Best get on with it then!

• Manish_

  Ten Centuries

  Points: 1070

  More actions

  May 25, 2004 at 12:54 am

  #507583

  Mr Anil

  you had told that "The function of the trigger should insert details of the students in the Remarks Field."

  but please tell me that where is the remark field in which table it is . or it is in "issue_details"  table only ?

  and then i can do some thing ....

   

   

   

   

  - Manish

• ANIL MAHADEV

  Old Hand

  Points: 345

  More actions

  May 25, 2004 at 10:25 pm

  #507789

  Dear Manish,

  Here is the problem.

  I have to create a trigger which will be invoked when a contest has been deleted from the contest table.

  Before Deletion the contest_cd,contest_des,comp_cd and

  dt_of_withdraw (Columns' Data ) will be

  stored in a table called contest_hist table.

  At the same time all corresponding records from tables called CON_ANS and QUES_ANS

  should be deleted.

   

  Here is the Table Structures for

  and Contest_hist.

  contest_cd

  contest_des

  comp_cd

  dt_of_withdraw

   

  I hope this is enough info. If not reply to me and I will send additional Info.

   

  I thank you 4 responding to my problem.

  .

  Best Regards

   

  Anil Mahadev