我在保存我的数据时候:出现错误对话框如下,出现下面的原因可能是什么导致的???谢谢大哥了(初学者留)
Bind parameter value for ':7' is too big(8)
No change made to database!
insert into t_jzgjbxx("t_id","name") values (???????????)
(注:)我用的结构来存我的数据,通过参数提交数据!
...全文
12412打赏收藏
又一高分送给大哥们:有事想求!!
我在保存我的数据时候:出现错误对话框如下,出现下面的原因可能是什么导致的???谢谢大哥了(初学者留) Bind parameter value for ':7' is too big(8) No change made to database! insert into t_jzgjbxx("t_id","name") values (???????????) (注:)我用的结构来存我的数据,通过参数提交数据!
ballonman:非常干谢你的建议,但是20不是我插入的数据,当然不是什么数字或者字符拉,我的20是长度,但是我长度页试过了,变小或者变大都没有办法。看看我的代码:long ll_row
integer li_rtn
string ls_zyid
mod_inwork lstr_mod_inwork
lstr_mod_inwork.add_or_mod="add"
openwithparm(w_edit_inwork,lstr_mod_inwork,parent)
lstr_mod_inwork=Message.PowerObjectParm
If lstr_mod_inwork.cancel="Cancel" then return
ll_row=dw_1.insertrow(0)
dw_1.setrow(ll_row)
dw_1.scrolltorow(ll_row)
dw_1.selectrow(0,false)
dw_1.selectrow(ll_row,true)
dw_1.object.zy_id[ll_row]=lstr_mod_inwork.zy_id
ls_zyid=lstr_mod_inwork.zy_id
dw_1.object.zyxm[ll_row]=lstr_mod_inwork.zyxm
dw_1.object.bm_id[ll_row]=lstr_mod_inwork.bm_id
dw_1.object.xb[ll_row]=lstr_mod_inwork.xb
dw_1.object.jg_id[ll_row]=lstr_mod_inwork.jg_id
dw_1.object.zw_id[ll_row]=lstr_mod_inwork.zw_id
dw_1.object.zc_id[ll_row]=lstr_mod_inwork.zc_id
dw_1.object.xl_id[ll_row]=lstr_mod_inwork.xl_id
dw_1.object.csrq[ll_row]=lstr_mod_inwork.csrq
dw_1.object.jtdh[ll_row]=lstr_mod_inwork.jtdh
dw_1.object.gzdh[ll_row]=lstr_mod_inwork.gzdh
dw_1.object.sjhm[ll_row]=lstr_mod_inwork.sjhm
dw_1.object.chhm[ll_row]=lstr_mod_inwork.chhm
dw_1.object.sfzh[ll_row]=lstr_mod_inwork.sfzh
dw_1.object.yhzh[ll_row]=lstr_mod_inwork.yhzh
dw_1.object.yzbm[ll_row]=lstr_mod_inwork.yzbm
dw_1.object.gl[ll_row]=lstr_mod_inwork.gl
dw_1.object.drsj[ll_row]=lstr_mod_inwork.drsj
dw_1.object.txdz[ll_row]=lstr_mod_inwork.txdz
li_rtn=dw_1.update()//大哥们:我出错的地方,请给与指导!!
If li_rtn=1 then
commit using sqlca;
else
messagebox("保存数据","保存数据时发生错误!")
rollback using sqlca;
return
end if
我也用过insert也没有办法,用insert时候,在messagebox提示时候,提示成功的,但是就是没有办法update!!
SQLCA.AutoCommit = True
UPDATEBLOB people_in_work SET grjl = :gb_grjl WHERE zy_id = :ls_zyid USING sqlca ;
IF Sqlca.SQLNRows > 0 THEN
COMMIT USING SQLCA;
END IF
UPDATEBLOB people_in_work SET photo=:gb_photo WHERE zy_id = :ls_zyid USing sqlca;
IF Sqlca.SQLNRows > 0 THEN
COMMIT USING SQLCA;
END IF
SQLCA.AutoCommit = False
long ll_row
integer li_rtn
string ls_zyid
mod_inwork lstr_mod_inwork
lstr_mod_inwork.add_or_mod="add"
openwithparm(w_edit_inwork,lstr_mod_inwork,parent)
lstr_mod_inwork=Message.PowerObjectParm
If lstr_mod_inwork.cancel="Cancel" then return
ll_row=dw_1.insertrow(0)
dw_1.setrow(ll_row)
dw_1.scrolltorow(ll_row)
dw_1.selectrow(0,false)
dw_1.selectrow(ll_row,true)
dw_1.object.zy_id[ll_row]=lstr_mod_inwork.zy_id
ls_zyid=lstr_mod_inwork.zy_id
dw_1.object.zyxm[ll_row]=lstr_mod_inwork.zyxm
dw_1.object.bm_id[ll_row]=lstr_mod_inwork.bm_id
dw_1.object.xb[ll_row]=lstr_mod_inwork.xb
dw_1.object.jg_id[ll_row]=lstr_mod_inwork.jg_id
dw_1.object.zw_id[ll_row]=lstr_mod_inwork.zw_id
dw_1.object.zc_id[ll_row]=lstr_mod_inwork.zc_id
dw_1.object.xl_id[ll_row]=lstr_mod_inwork.xl_id
dw_1.object.csrq[ll_row]=lstr_mod_inwork.csrq
dw_1.object.jtdh[ll_row]=lstr_mod_inwork.jtdh
dw_1.object.gzdh[ll_row]=lstr_mod_inwork.gzdh
dw_1.object.sjhm[ll_row]=lstr_mod_inwork.sjhm
dw_1.object.chhm[ll_row]=lstr_mod_inwork.chhm
dw_1.object.sfzh[ll_row]=lstr_mod_inwork.sfzh
dw_1.object.yhzh[ll_row]=lstr_mod_inwork.yhzh
dw_1.object.yzbm[ll_row]=lstr_mod_inwork.yzbm
dw_1.object.gl[ll_row]=lstr_mod_inwork.gl
dw_1.object.drsj[ll_row]=lstr_mod_inwork.drsj
dw_1.object.txdz[ll_row]=lstr_mod_inwork.txdz
li_rtn=dw_1.update()//大哥们:我出错的地方,请给与指导!!
If li_rtn=1 then
commit using sqlca;
else
messagebox("保存数据","保存数据时发生错误!")
rollback using sqlca;
return
end if
SQLCA.AutoCommit = True
UPDATEBLOB people_in_work SET grjl = :gb_grjl WHERE zy_id = :ls_zyid USING sqlca ;
IF Sqlca.SQLNRows > 0 THEN
COMMIT USING SQLCA;
END IF
UPDATEBLOB people_in_work SET photo=:gb_photo WHERE zy_id = :ls_zyid USing sqlca;
IF Sqlca.SQLNRows > 0 THEN
COMMIT USING SQLCA;
END IF
SQLCA.AutoCommit = False