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
|
