Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Unanswered: Bit more specific, Can one pass an NVARCHAR to IF UPDATED()?

    Question is pretty much in the thread title.

    I'm still plunking away on a history trigger that requires the evaluation of whether or not each column has been updated. If it has,t hen I'll be tossing a record into a history table.

    Basically I need something to function along the same logic as this:

    IF UPDATED(@s)
    BEGIN
    --some code
    END

    Any thoughts you folks may have are greatly appreciated.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

    -PatP

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by Pat Phelan
    About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.

    -PatP
    At least it's something to go on. I'll take a look at it tomorrow.

    Much obliged good sir.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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