On 5 Nov 2001, at 19:38, Luiz Alves wrote:

> Does your view have triggers?

Yes, One Before Insert and one Before Update.

The one before insert generate a new number for underlying table
(There is no trigger on the underlying table).

The one Before update has one statement like
new.fieldA = old.FieldA
to ensure the value is not changed accidentally

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz