Re: FRM-40401: No changes to save

In article <7pq3nk$1jm$1_at_nnrp1.deja.com>, <daud11_at_hotmail.com> wrote:
> I added the statement " Forms_dd('commit;'); " and I did not get the
> message anymore. However, I found that my data did not get saved.
> Let me tell you more on what I have on my form:

It is supposed to be Forms_DDL('COMMIT'); I assume you did not leave out the L in DDL, and you should NOT include the first semicolon. Also, immediately afterward, you need to check: IF NOT FORM_SUCCESS THEN... But you might consider doing this:

Issue your UPDATE sql statements, then:
:SYSTEM.MESSAGE_LEVEL := 5;
COMMIT_FORM;
:SYSTEM.MESSAGE_LEVEL := 0;
IF FORM_STATUS <> 'QUERY'
OR NOT FORM_SUCCESS THEN
  ...
END IF;
>1) On my forms there are a few text boxes which do not bind to base
>table
>2) User will key in the info and then click on the Save button
>3) The save button is supposed to have the code to save this data to
>the base table and I am having problem whenever I include the commit
>statement - I get the message "FRM-40401: No changes to save"
Received on Mon Aug 23 1999 - 06:50:44 CEST