Re: [Firebird-net-provider] How can I execute several commands in a single FbCommand object

[Pierre A. <pie...@op...>]

> Can you etst this using the latest CVS sources ??

OK. I've been able to download CVS sources. Last entry in
Changelog is dated 2003-10-04.


I can confirm that following code does not work:

   command.CommandType = System.Data.CommandType.Text;
   command.CommandText =
    "CREATE TABLE A(F1 INTEGER NOT NULL, F2 INTEGER NOT NULL);" +
    "ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (F1, F2);";
   command.Transaction = my_transaction;

   reader = command.ExecuteReader ();

   for (;;)
   {
     while (reader.Read ())
     {
       System.Console.Out.WriteLine ("{0} columns found.",
                                     reader.FieldCount);
     }
     if (reader.NextResult () == false)
     {
       break;
     }
   }
   reader.Close ();

I get an exception thrown in the first call to Read() with
"invalid request handle" as explanation.

I get the following trace:

    Read()
      GdsStatement.Fetch, line 523
        GdsAttachment.ReceiveResponse, line 319
          GdsAttachment.ReadStatusVector, line 222

    with arg = 0x1 and er  = 0x14000007

Do you have any idea how to fix this ?

    Pierre