Hi Again,

I found the problem. PB 'generated' some connection code that
included setting autocommit to true.

Brian

--- In firebird-support@yahoogroups.com, "Brian" <bpeasey@...> wrote:
>
> Hi Helen,
>
> Thanks for the quick reply.
>
> I'm using Sybase's PowerBuilder 9. There is an autocommit on/off
> feature, that works with Oracle, but doesn't seem to have the same
> effect with FB. I wonder if it could be PowerBuilder not working
> correctly with driver.
>
> While writing this I stopped to see what driver version I have.
Turns
> out it's from 2004 (26 Aug 2004 V. 1.2.1 (1.2.0.69)). Will try the
> newest tomorrow to see if there's any difference.
>
> Brian
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@>
wrote:
> >
> > At 07:22 AM 18/03/2008, you wrote:
> > >Hi,
> > >
> > >How does autocommit work with FB? I want to manage my own
transactions
> > >in the client code, but updates seem to be automatically
committed
> > >without me issuing my own commit statements. Is there a property
in db
> > >I can change via sql or the command line to turn of autocommit?
> >
> > "Autocommit" is a client-side concept, whereby your driver layer
is
> set up to work around transaction control and commit every statement
> as soon as the client posts the DML request. The concept exists
more
> for historical reasons than anything else, dating back to the days
> when Borland marketed its RAD products by encouraging customers to
> believe that making a client/server RDBMS behave like a desktop
> database engine was a powerful feature.
> >
> > >P.S. I'm using the embedded version of FB, if that makes a
difference.
> >
> > You're not getting this autocommit behaviour as a result of using
> embedded, if that answers your question. You're getting undesirable
> default behaviour from your language interface layer, whatever it
is.
> There will be some settings (properties, members, etc., depends on
> language) that enable you to configure your transactions.
> >
> > If you need help with this, tell us what you are using as your
> language interface.
> >
> > ./heLen
> >
>