Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Unanswered: Trigger question

    How do I change value of a column on a before insert trigger on a table?

    begin atomic
    set new.mycol1 = 'abcd', new.mycol2='xyz';

    end

    What's the best way ?

  2. #2
    Join Date
    Aug 2004
    Posts
    330
    Yes, setting the transition variables(NEW.) is the way to do it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •