Results 1 to 2 of 2

Thread: Triggers

  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: Triggers

    Hey again, im getting a reqular poster here, lol!
    My query this time is with triggers. If i want to insert a character into a column when an update takes place what shoudl i be writing?
    The column i want to insert into is criminal_event and want to add a T here.
    Ive tried:
    SET CRIMINAL_EVENT = 'T'
    END;
    but it is not happy, any help?

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: Triggers

    Hi,

    can you post the full trigger definition? It will be easier to help you then.

    Johann

    Originally posted by English_Bloke82
    Hey again, im getting a reqular poster here, lol!
    My query this time is with triggers. If i want to insert a character into a column when an update takes place what shoudl i be writing?
    The column i want to insert into is criminal_event and want to add a T here.
    Ive tried:
    SET CRIMINAL_EVENT = 'T'
    END;
    but it is not happy, any help?

Posting Permissions

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