Re: [Firebird-net-provider] Bug with multiple commands in same transaction

[Denis D. <fir...@De...>]

Hi,
about your replay to:

> > - Created transaction with IsolationLevel.RepeatableRead.
> > - Executed two commands using FbCommand, while keeping the
> >   same transaction active :
> >
> >   (1)  CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
> >   (2)  INSERT INTO X(A, B) VALUES (1,1);
>
> I think it's working ok, as the first command is not committed yet.

Certainly not, transactions are conceptualy for making a serie of SQL
command, and then commit (or rollback) all of them if ok (or not)

(1) START TRANSACTION
(2) CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
(3)  INSERT INTO X(A, B) VALUES (1,1);
(4) COMMIT / END TRANSACTION

should work, without "commit" in the middle.
Is'nt that true ?

Best regard,
-- 
Denis Dumoulin