UPDATE TRIGGER for a specific record


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: UPDATE TRIGGER for a specific record

  1. #1
    Edwin Guest

    UPDATE TRIGGER for a specific record


    I'm having a hard time finding out how to get an update trigger to update
    a column in specific table.

    If the user updates column A I would like his workstation and the time she
    updated column A to be updated in column B and C of the same table. Any ideas?


  2. #2
    Bernie Guest

    Re: UPDATE TRIGGER for a specific record


    "Edwin" <vbedluciano@hotmail.com> wrote:
    >
    >I'm having a hard time finding out how to get an update trigger to update
    >a column in specific table.
    >
    >If the user updates column A I would like his workstation and the time she
    >updated column A to be updated in column B and C of the same table. Any

    ideas?
    >


    Hi,

    Check out our previous discussion at March 17,
    'Logging changes for a specific table/column'.
    That will give you the answer...

    Bernie

  3. #3
    Edwin Guest

    Re: UPDATE TRIGGER for a specific record


    Thanks Bernie, I got it to work.


    "Bernie" <magnus.bernroth@rejlers.se> wrote:
    >
    >"Edwin" <vbedluciano@hotmail.com> wrote:
    >>
    >>I'm having a hard time finding out how to get an update trigger to update
    >>a column in specific table.
    >>
    >>If the user updates column A I would like his workstation and the time

    she
    >>updated column A to be updated in column B and C of the same table. Any

    >ideas?
    >>

    >
    >Hi,
    >
    >Check out our previous discussion at March 17,
    >'Logging changes for a specific table/column'.
    >That will give you the answer...
    >
    >Bernie



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center