Hi,

What I'm trying to do is:

I have a table named "contribuintes" this table has several fields, including the fileds:

numeroposto, cod_rep_fiscal and NIF.

I want that, if an update takes place and the value of the column numeroposto is updated to "Central", then

The trigger sees if the "NIF" value was changed.

If it was changed, then it needs to get back to the same value it had before the update.

At the same time, if the column "cod_rep_fiscal" was changed and the new value does not exists in the view V_RETURN_RF then it needs to be chamged again to it's original value.

Thanks