Triggers

English_Bloke82 · #1 (**permalink**) 02-12-04, 10:05

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?

jsander · #2 (**permalink**) 02-12-04, 12:30

Hi,

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

Johann

Quote:

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?

Internet Services

Web Development

Digital Marketing

Consumer Tech