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

preetha.christopher_at_gmail.com wrote:
> Hi,
> 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

Put the commit into the procedure and don't post questions in the future without listing Forms and database versions.

Daniel Morgan
www.psoug.org Received on Fri May 05 2006 - 00:16:20 CEST