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?

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________