Subject Re: [ib-support] problem with Employee database
Author Helen Borrie
At 12:54 PM 17-08-02 -0300, you wrote:
>I've seen the constraint (named INTEG_54), but it says
>CHECK (percent_change between -50 and 50)
>and, as far as I can see, if you do update column old_salary to any value,
>column percent_change doesn't change... the value is in range as it is in
>the table.

Correct: percent_change is not a computed column. However, when you
commit a valid change, new_salary changes, because it is a computed column.

>Besides... i can't see where the error message
>'validation error for column OLD_SALARY, value "0.00 "'
>comes from

It comes from the database - it is returned in the error array. Does that
answer the question you intended to ask?


All for Open and Open for All
Firebird Open SQL Database · ·