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
>