Post reply

Trigger Help

  • 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

  • May 24, 2004 at 5:19 am

    #507444

    Best get on with it then!

  • 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

  • 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

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply