Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!tethys.csu.net!nntp.csufresno.edu!sn-xt-sjc-02!sn-xt-sjc-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: psql commit Date: Fri, 03 Mar 2006 12:34:22 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1141418054.538341@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 27 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125678 tony wrote: > Thanks for the replies. The subject should say plsql....it was the > end of a long day ; ) I'll try to explain my question more fully. > > BEGIN > IF X = '1' THEN > UPDATE mytable > SET myfield = 1 > WHERE id=idIn; > > htp.print('Thank you!); > ELSE > htp.print('Operation failed') > END IF; > END > > Does the commit occur after the WHERE clause or not until END? > > thanks again, > tony For the update statement above ... no commit ever takes place. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)