Re: Forms

From: Curtis Gourley <curtis.gourley_at_srs.gov>
Date: 1997/01/20
Message-ID: <1997Jan20.114034.8259_at_srs.gov>#1/1

Pat Doran wrote:
>
> I am newish to Oracle forms and have a question that I have been unable
> to solve. I have created many forms the that have several blocks from
> different tables, when the users update any block (that is not the
> MASTER block of the form) and press the save button (the default one
> forms creates) Forms comes back with the following error:
>
> FRM-40405
> No Changes to apply
>
> But the updates to the blocks (and tables they represent) do occur!!!!
> How can get rid of this error message?? I assume I am getting the
> message because the button refer to the the master block, right?
>
> Thanks......
> --
> Patrick J. Doran
> Applications Engineer
> Lucent Technologies, Microelectronics
> Email: pdoran_at_lucent.com
> Phone: (610) 391-2747
> Fax: (610) 391-3050
> Address: 9999 Hamilton Blvd
> Breingsville,PA 18031-9359
> Room 33A-130E
>
> ***************************************************************************
> NOTE: AS A RESULT OF THE AT&T / LUCENT SPLIT, OUR E-MAIL SYSTEM IS IN A
> STATE OF FLUX. IF I DO NOT RESPOND IN A TIMELY MANNER TO
> YOUR E-MAIL, PLEASE EITHER:
> 1) RESEND WITH YOUR E-MAILER REQUESTING AN AUTO-ACKNOWLEDGEMENT
> 2) CALL OR FAX ME AT THE DIRECT NUMBERS ABOVE
> ***************************************************************************

I am new also.
I ran into FRM-40401
No changes to save.

I created an ON-ERROR trigger for the form containing: DECLARE

  lv_errcod  NUMBER          := ERROR_CODE;
  lv_errtyp  VARCHAR2(3)	 := ERROR_TYPE;
  lv_errtxt  VARCHAR2(80)	 := ERROR_TEXT;

BEGIN
  IF (lv_errcod = 40401) THEN

        MESSAGE(Your message or NULL;.');
  ELSE

	MESSAGE(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);
	RAISE Form_Trigger_Failure;

  END IF;
END; Someone here was able to help me set it up. Hope this will work in your situation.

Curtis Received on Mon Jan 20 1997 - 00:00:00 CET