Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    56

    Unanswered: TRIGGER with @variable

    Hi,
    is it possible to determine which field was updated in an AFTER UPDATE TRIGGER?

    Or is it possible to save data in @variables in a BEFORE UPDATE TRIGGER and read the @variables in an AFTER UPDATE TRIGGER?

    Or can I determine which row will be updated in a BEFORE UPDATE TRIGGER (like by reading the id of the primary key from a system variable)?


    Thanks,
    David
    Last edited by vivoices; 04-24-10 at 07:37.

  2. #2
    Join Date
    Jul 2009
    Posts
    56
    No need for variables, using the aliases OLD and NEW solves one problem.

Tags for this Thread

Posting Permissions

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