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 sa
Helen,
I created a view as you said.
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
;
Then create a trigger for the view:
CREATE OR ALTER TRIGGER V_T_BALANCE_AUD0
At 08:03 PM 29/11/2011, ibmcom2011 wrote:
>heLen,
>
>Thanks.
>
>I found I should add a "with check option" to the end of a updatable view in
>the introduction of FB2.0. Now my FB version is 2.5.
>
>But the option requires a where sub-clause, and I don't know how to do.
Do you have a WHERE clause
heLen,
Thanks.
I found I should add a "with check option" to the end of a updatable view in
the introduction of FB2.0. Now my FB version is 2.5.
But the option requires a where sub-clause, and I don't know how to do.
And Now, I have a suppose on my trigger. For the Column YE is not be updated
Sorry.
The description is a part of my trigger, some infomation was omitted.
Originally, I want to explain it simply, but difficult to see.
The trigger is a After Update & Delete trigger.
TABLE1 structure (show simply)
ID -- Num1 -- Num2 - BALANCE
1 --- 15 -