** Trigger Problem, please help **
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.
This error is returned when a triggered SQL statement acts
on the triggering table, or when both statements are updates
and the column being updated in the triggered action is the
same as the column being updated by the triggering
statement.
Potential responders, please reply to my email address as well as the
Newsgroup. Thank You.
The Update
----------
update my_table set a=27 where a=1;
The Table
---------
{ TABLE my_table row size = 4 number of columns = 2 index size = 0 }
create table my_table
(
a smallint,
b smallint
default 0
);
The Trigger
-----------
create trigger t1 update on my_table before
(
update my_table set my_table.b = 999 );