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