Article View: borland.public.interbase.sql
Article #37Re: how I can make the stored procedure see its changes during running
From: Bill Todd [TeamB]
Date: Fri, 23 May 2008 00:31
Date: Fri, 23 May 2008 00:31
17 lines
1791 bytes
1791 bytes
Isaac wrote: > In my stored procedure there two updates, the last update sum a field > changed by the first update, but because data is not committed the > last update see an old value, If you start a transaction, update a table, then read the values in the updated rows you will see the new values. A transaction can always see uncommitted updates that it has made. if you cannot see the updated values the only possible reason is that you are not using the transaction that made the updates. This is why it is very important to explicitly start and end every transaction in code. Do not let your data access components start and end transactions automatically because you can never be sure when transactions are started and ended. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<48361077@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4835d989@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,95eb8734d0771ad2
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: how I can make the stored procedure see its changes during running
Newsgroups: borland.public.interbase.sql
References: <4835d989@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 65.118.176.23
Message-ID: <48361077@newsgroups.borland.com>
Date: 22 May 2008 17:31:51 -0700
X-Trace: newsgroups.borland.com 1211502711 65.118.176.23 (22 May 2008 17:31:51 -0700)
Lines: 17
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail