Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread How do FlushBuffers affect a transaction
Thu, Feb 5 2009 8:11 PMPermanent Link

"Paul Coshott"
Hi All,

Is there a problem if a flushbuffers is used within a transaction ? I have a
procedure that is sometimes used on it's own, so I want the flushbuffers to
be used, but I also need to use this procedure from within another procedure
that starts a transaction.

Any problems with this?

Cheers,
Paul

Sat, Feb 7 2009 2:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Paul,

<< Is there a problem if a flushbuffers is used within a transaction ? >>

No, that will not be an issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 9 2009 11:25 AMPermanent Link

"Robert"

"Paul Coshott" <paul@pacsoftware.com.au> wrote in message
news:02D8F49E-19FA-426B-99CB-06D1BC3EE9D9@news.elevatesoft.com...
> Hi All,
>
> Is there a problem if a flushbuffers is used within a transaction ? I have
> a procedure that is sometimes used on it's own, so I want the flushbuffers
> to be used, but I also need to use this procedure from within another
> procedure that starts a transaction.

why not code it

if not database.intransaction then flushbuffers

Robert

Image