1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Change one column based on the information in another column with Triggers

Discussion in 'General' started by hairytoe, Sep 10, 2010.

  1. hairytoe

    hairytoe Guest

    Hello,

    I am trying to create a trigger which changes the content of one column based on the informwtion within another colunm.

    For Example, if the 'ITEMQUANTITY' field drops below 1 then I want the STATUS column to say 'Out Of Stock'.

    Is this possible?

    Thanks
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: Triggers

    It is very difficult to say based on the sketchy information that you have given. What it seems is that you will run into the Mutating error. However someone can provide more information, if you share your table structure and your code and what exactly you are trying to do.
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455