Re: FRM-40405 : No changes to apply error.

[Quoted] On Friday, October 21, 2005 7:12:06 AM UTC-5, sidd..._at_yahoo.com wrote:
> Hi,
>
> I have problem with FRM-40405 : No changes to apply error.
>
> Explanation of the problem:
> -----------------------------
> I have two forms form1,form2.
> I am opening form2 from form1 and issuing a commit_form statement in
> form2.It throws me the error first and then it says "transaction
> completed x records saved.'.
>
> I know that the error is from form1.but I cannot trap this by putting
> an on-error trigger in form1 since it will change the default
> behavior(i.e if user tries to save without any chnages it won't prompt
> with any error if i suppress it).
>
> So i want to know is there any other work around to get rid of this
> problem.
>
> Note: I am using Open form with no_session.
>
> Thanks in advance.
> Siddhardha.

You may be focused on the wrong form. If the form is opened from another form using OPEN_FORM then it's possible the message is actually being thrown from the parent or calling form (see documentation for OPEN_FORM built-in). When the value of parameter session_mode is NO_SESSION (the default) then the child form shares the same session as the parent form. The implication is commits in the child form will also cause change validation processing in the parent form too. If the parent form doesn't have any changes to save then you'll likely see this message. By specifying SESSION for the session_mode parameter the child form will open into it's own session. Received on Fri May 23 2014 - 17:49:22 CEST