Re: ** Trigger Problem, please help **

Billy Wheeler wrote: > > > Version : RSAM Version 7.10.UC1 > 5> > > 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? > > No - triggers can't affect/alter the row which fires up the trigger. > > HTH. > -- > > Ciao, > > Billy > > NOTE: 1000's of free sex pictures at http://*&^*%!#+^|@$*)(?><"NO CARRIER ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ !!!! Hi Billy, I've tried this URL, but it didn't work !!!! Hi Billy, I think that's not correct. If you want to modify another column of your table, that is not included in the column-list of the update-trigger, this should be possible. But what you need is a column-specific update-trigger, instead of a table-level trigger. create trigger t1 update of A on my_table referencing new as n old as o (for each row ( execute procedure uhps( n.A ) into n.B ); This example would store the value - returned by the procedure uhps - in the column B of the cirrent row. Bye Stefan stefan@weideneder.de