Not that this will make any difference, but I did not think having a colon before new.page and new.calcno was optional.
Also, do a DESCRIBE STYLES to see what that table structure is. Since you do not fully qualify the table, make sure your [public] synonym for STYLES points to the correct schema.
>OK ... This one is wierd...
>
>I have a trigger :
>
>CREATE OR REPLACE TRIGGER COST5_FDB
>BEFORE INSERT OR UPDATE ON "COST5"
>FOR EACH ROW
>WHEN (new.page=1 and new.calcno=1)
>BEGIN
> update styles set moc002='ttetet' where mainkey='0000000024';
>END;
>/
>
>For some reason it will not update any varchar2 columns!
>If I change the field moc002 to a date or number field the update works
>correctly.
>
>i.e.
>update styles set mon001=11 where mainkey='0000000024';
>
>
>-There are no other triggers on either table.
>-If I install the rigger on another table it works fine...
>
>Any ideas....
Mark McCasland
Midlothian, TX USA