Archives of the TeradataForum

Message Posted: Fri, 21 Apr 2006 @ 13:44:11 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Trigger Problem

From:		Victor Sokovin

Allen: I think I would try making the trigger a BEFORE instead of an AFTER. It shouldn't matter, but of there is a bug and it is looking at the buffer, who knows?

Interesting.

Isn't it, Michael? I've tried your suggestion but "BEFORE row triggers cannot have data-changing statements as triggered action SQL statements". At least in this area we seem to be ANSI compliant.

Regards,

Victor