At 09:45 PM 8/06/2012, Kjell Rilbe wrote:

>Hi,
>
>Please remind me, is it the case that you can only have a single active
>transaction per connection?

Absolutely not the case!

>But you can have any number of commands/queries open for that single
>transaction and connection?

You can have any number of transactions running in one connection. You can have any number of active statements in any transaction. For example, for an interactive program you usually need to have long-living selector sets running in read-only read committed transactions, while you want rapid-fire, high contention modification work in read-write snapshot transactions...and so on.

>This is in .Net and I'm using the FB provider version 2.6 or 2.7 I think.

What any API host language interface supports (or not) is the business of client application, i.e., what the HL interface supports isn't always the whole of the API. The BDE, for example, dragged the InterBase API down about as low as it would go, to make it seem like Paradox or dBase III to the developers of early Delphi and C++Buillder. And the situation with the BDE is one connection, one transaction and autocommit on every operation. (Yep, I was alive in those days!) So your question is for the firebird-net-provider list. I'd be extremely surprised if, this far on in its life, the .net provider didn't fully support the Firebird API.

./heLen

>Kjell
>
>--
>--------------------------------------
>Kjell Rilbe
>DataDIA AB
>E-post: kjell@...
>Telefon: 08-761 06 55
>Mobil: 0733-44 24 64
>
>
>
>------------------------------------
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>Yahoo! Groups Links
>
>
>