Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Thu, 04 May 2006 15:16:20 -0700
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: FRM-40654: Record has been updated.Requery block to see change
 and FRM-40401: No changes to save
References: <1146719940.672004.204800@i39g2000cwa.googlegroups.com>
In-Reply-To: <1146719940.672004.204800@i39g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1146780982.578419@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 38
X-Complaints-To: abuse@csolutions.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:70750

preetha.christopher@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