Database Trigger UPDATE 1

[prosuc]

I have a table named
TEST_TABLE
COD_A NUMBER(1)
FIELD_1 NUMBER(7)
DESC VARCHAR2(10)

I have a trigger AFTER UPDATE on FIELD_1, when I update the the field DESC via SQL, the database trigger doesn't fire, and this is fine, but if I update the field DESC via FORM, the database trigger fire!!!!

why???!!!

Forms update all the fields into the database???
even when I change just one field???

my configuration is ;
FORMS 6i
ORACLE 9i

 

[lewisp]

In the block properties on your form, set the Update Changed Columns Only to 'Yes'.

 

[prosuc]

thanks GURU!