Re: FORMS 3.0 Clear Field Question

Adam Hoffman (hoffma_at_rpi.edu) wrote:
:> I am trying to create a procedure in FORMS 3.0 where when
:> the user clears a field, several other fields in the same block
:> also clear. The whole block should not clear, just certain
:> fields. Does anyone have any suggestions since I do not see
:> a function for KEY-CLRFLD or ON-CLRFLD. Thanks.

Create an ON-VALIDATE-FIELD trigger on your field. IF :FIELD IS NULL
Put a procedure call to clear_other_fields. END IF Create a procedure clear_other_fields.
it contains

	GO_FIELD ('FIELD1') ;
	CLEAR_FIELD ;
        GO_FIELD ('FIELD2') ;
	CLEAR_FIELD ;


	GO_FIELD ('BACK_TO_WHERE_WE_WERE_FIELD_NAME') ;

Much more info in SQL*Forms Designer's Reference Version 3.0 Oracle Manual

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.