[Firebird-net-provider] DBNull.Value

[Jan J. <fb...@ja...>]

Hi,
When i execute this code (.NET provider 1.0 or 1.5b1, Firebird 1.0.3 or
1.5R6, WinXP), all values >=1 is NULL...

===================================================
// create table tbTest(
//    p1 char(10)
// );
FbCommand comm = new FbCommand(
       "insert into tbTest(p1) values(@p1);",
       conn,
       tran
       );
FbParameter p1 = new FbParameter("@p1", FbType.Char);
comm.Parameters.Add(p1);
comm.Prepare();

for(int i = 0; i < 5; i++) {
   if(i = 1)
      p1.Value = DBNull.Value;
   else
      p1.Value = i.ToString();
   comm.ExecuteNonQuery();
}
tran.Commit();
===================================================

Regards,

Jerry