FRM-40654: Record has been updated.Requery block to see change and FRM-40401: No changes to save

From: <preetha.christopher_at_gmail.com>
Date: 3 May 2006 22:19:00 -0700
Message-ID: <1146719940.672004.204800_at_i39g2000cwa.googlegroups.com>

Hi,
[Quoted] I have created a custom form which updates the contents of a custom table.
The updation is done by calling a procedure from a pre-existing project. The code goes like:

Call update_procedure;

Commit;

Exit_form(no_commit, no_rollback); --To exit the form as soon as the changes have been commited

The updation goes fine but after commiting, the form raises FRM-40401: No changes to save error. It occurs due to the exit_form I think. I have tried every type of exit_form but nothing works. Can someone give me a solution.

The data which is updated is displayed in another form (2). After I run my form, if I try to alter the displayed data in form 2 I get the FRM-40654: Record has been updated.Requery block to see change, error.

The Form2 also seems to call the update_procedure, but doesnt do a commit or exit_form.
Also the update_procedure simply updates the table without commit.

Is there a problem with my form or form 2. Please could someone tell me how to fix these 2 errors? I can only alter my form.

Thanks in advance,
Preetha Received on Thu May 04 2006 - 07:19:00 CEST