老是报null值不能插入Not null列,但我的所有变量都是有值,因为我的表中有非空字段:
with table1 do
insert
....post
end

解决方案 »

  1.   

    With Table1 Do
      begin
       Edit;
       Insert;
    .......................
    ..................
    ...............
       Post;
      end;
      

  2.   

    报错:[IBM][CLI Driver][DB2/LINUX] SQL0401N  运算 "=" 的操作数的数据类型不兼容。  SQLSTATE=42818                  with  Table1 do
                                begin
                                    edit;
                                    
                                    insert;
                                    
                                    FieldByName('comid').AsString:=gpdm;
                                    FieldByName('seq').AsInteger :=strtoint(infoid);
                                    FieldByName('whltype').AsString:=whltype;
                                    FieldByName('b_date').AsString :=fsrq2;
                                    FieldByName('subject').AsString:=zt;
                                    FieldByName('pubtime').AsString:=edittime;
                                    FieldByName('status').AsString :='P';
                                    FieldByName('content').AsString :=nr;
                                    Post;
                            end;
    表中有非空字段
      

  3.   

    pascal语言是强制类型转换的,所以你要确保=的两边类型一致;另外,请检查一下你创建的表中,是否有在设计时有字段定义为不能空,而你在插入的时候却没有进行插入祝好运!