Thanks for the response. Do I need to declare a transaction in the application layer then?

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> sqlsvr wrote:
> >From the documentation, every query executed against Firebird will be automatically put in a transaction.
> >
> > So, is there any point in declaring a transaction from the application layer
> > (a .NET web application in this case using the Firebird Native Provider)?
>
> Clarity. Unless you specify that you want autocommit, all statements
> execute in the same transaction until you commit it or roll it back.
> Starting transactions explicitly makes their boundaries obvious to the
> next person who tries to extend your code.
>
> Good luck,
>
> Ann
>