Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Netherlands
    Posts
    3

    Question Unanswered: passing variables from user procedure to trigger

    Hi all,

    Is it posible to refer in a trigger to variabels wich I use in a user procedure wich fired the insert update or delete statement wich triggerd the trigger.

    Help appriciated,

    Andrew

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I just tested this out and it worked. You can create a temporary table in the stored procedure and load it up with your parameters, then have the trigger select from the temporary table to get the values.
    The temporary table does not have to be global.
    MCDBA

  3. #3
    Join Date
    Nov 2002
    Location
    Netherlands
    Posts
    3
    Originally posted by achorozy
    I just tested this out and it worked. You can create a temporary table in the stored procedure and load it up with your parameters, then have the trigger select from the temporary table to get the values.
    The temporary table does not have to be global.


    Simple but briljant,

    Thank you,

    Andrew

Posting Permissions

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