Results 1 to 2 of 2

Thread: Trigger Happy

  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unhappy Unanswered: Trigger Happy

    Hi,

    Working on some coursework and wondered if anyone could help us.

    We have set up a table that is supposed to be a log of whenever another table is updated. We have looked and looked and tried and tried but cannot work out how to set the log table to automattically update.

    We assume that triggers are the best way but we aren't sure. Can anyone help?

    the tables are...

    entry(e_code, c_code, id, position)
    log(e_code, c_code, id, position stamp, user_id)

    where stamp is the time of the update and user_id who has done it.

    Any help would be greatly appreciated.

    Thankyou

  2. #2
    Join Date
    Nov 2002
    Posts
    2
    Don't worry

    All sorted now thanks

Posting Permissions

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