RAISE FORM_TRIGGER_FAILURE

[nouf]

HI,
I MAD A FORM , AND IN THE FIRST FIEL I MAD A TRIGGER TO CHECK ITS VALUE
THE TRIGGER IS (WHEN VALIDATE ITEM ):
------
IF :CONTROL.WO_NO IS NULL THEN
SHOW_MESSAGE('WO_NO CAN'T BE NULL');
RAISE FORM_TRIGGER_FAILURE;
END IF;

----
THE PROBLEM IS WHEN I TRY TO CLOSE THE FORM BY A BUTTON
WHICH I MAD TO EXIT IT STILLS GIVE ME THE MESSAGE AND CAN'T CLOSE...

SO HOW CAN I STOP ( RAISE FORM_TRIGGER_FAILURE )
ON EXIT;
THANKS..

 

[lewisp]

You could try programming the KEY-EXIT with

[tt]Exit_Form(NO_VALIDATE);[/tt]

or you could move the validation to pre-commit or somesuch.