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

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

Hello:

> I don't have ISQL, but I believe what you tell me. It just seems
> really strange. Adding the "SET AUTODLL OFF;" line in IBExpert
> causes also IBExpert to generate an error on the INSERT statement.

If you have firebird installed you have isql too, just see in the 
firebird bin directory ( isql.exe ).

> So how can I do what I want, namely create a table and fill it
> in, then rollback the table creation ?

But you don't want to mantain the table created after have it filled ?? 
In that case, Why not ?? :)

If you want to mantain it created after have it filled, and drop it if 
you get an error, at this moment you can do:

(1) Start transaction.
(2) Create table.
(3) Commit transaction (using Commit method)
(4) Start transaction.
(5) Fill the Table
(6) Commit transaction (using Commit method)

if you get an error when filling:

(1) Rollback transaction.
(2) Drop the table.

or:

(1) Start transaction.
(2) Create table.
(3) Commit transction (using CommitRetaining method.)
(4) Fill the Table.
(5) Commit transaction (using Commit method.)

if you get an error when filling:

(1) Rollback transaction.
(2) Drop the table.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

P.S.: I'm thinking on add to the FbCommand a new property called 
FbCommandType for allow to know which type of command is being executed, 
it will be possible to know it after have the statement prepared 
(GdsStatement has yet this information in the StatementType property), 
comments are wellcome ;)