Re: ** Trigger Problem, please help **
In <19961105160700.LAA11114@ladder01.news.aol.com>, belakimem@aol.com wrote:
>Version : RSAM Version 7.10.UC1
>
>I get the following error when I perform the update below. Yet, the manual
>suggests it is OK to perform updates on the same table in pudate triggers
>as
>long as you don't update columns referenced in the original update?
>
>-747 Table or column matches object referenced in triggering
>statement.
.
.
.
>The Trigger
>-----------
>
>create trigger t1 update on my_table before
> (
> update my_table set my_table.b = 999 );>
Try following usage :
create trigger t1 update of a on my_table before
(
update my_table set my_table.b = 999 );
Thanks
Felix Koshy Mathews