[Firebird-net-provider] How to use FbCommand with parameters ?

[Oliver E. <oe...@en...>]

Hi,
 
I tried to use a FbCommand to insert a single row into my database.
 
My DB is
 
CREATE TABLE (
   A_DISTRIBUTOR_ID Integer NOT NULL,
  A_salutation varchar(10),
  Primary key A_DISTRIBUTOR_ID
)
 
And my C#-Code is:
                  _cmdText = "INSERT INTO
T_DISTRIBUTOR(A_DISTRIBUTOR_ID,A_SALUTATION) ";
                  _cmdText += " VALUES(32,?) ";
 
                  _connection = new
FirebirdSql.Data.Firebird.FbConnection(m_ConnectString);
                  _command = new
FirebirdSql.Data.Firebird.FbCommand(_cmdText,_connection);
           
 
_command.Parameters.Add("salutation",FirebirdSql.Data.Firebird.FbDbType.Text
).Value = "blah";
      
                  _connection.Open();
                  _command.ExecuteNonQuery();
                  _connection.Close();
 
 
I get an Array out of Bounds Exception. What am I doing wrong ?