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

[<car...@te...>]

Hello:

> 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

I think it's working ok.

The CREATE TABLE is a DDL command and i think that will be not possible 
to make anything with the table until the transaction is commited.

I have make the same test using IBExpert and raises the same error.

The same can be applied to isql, try this on it:

SET AUTODDL OFF;
CREATE TABLE X(A INTEGER NOT NULL, B INTEGER);
INSERT INTO X(A, B) VALUES (1,1);

I get the same error.


If i'm wrong, please correct me :)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain