At 10:21 PM 29/11/2011, ibmcom2011 wrote: >Helen, > >I created a view as you said.
No, you didn't. >CREATE OR ALTER VIEW V_T_BALANCE( > F_ACD_ID, > NUM1, > NUM2, > BALANCE) >AS >select F_ACD_ID, NUM1, NUM2, BALANCE from FIN_ACC_CASH_DIARY >where 1 = 1 >with check option >; I said: >>But for the view for the purpose described, you should leave it unfiltered >>and apply a WHERE clause to it when you access it in the table trigger. You don't want CHECK OPTION. ./H