vfp数据类型不对,IF MESSAGEBOX("请确认数据正确,保存?",1+48,"确认!")=1 then kcsl1=thisform.kcsl1.Value UPDATE kc SET kcsl = kcsl-kcsl1 WHERE kc.cj=thisform.cj1.Value AND kc.xl=thisform.xl1.Value AND kc.pm
来源:学生作业帮助网 编辑:六六作业网 时间:2025/01/13 04:28:14
vfp数据类型不对,IF MESSAGEBOX("请确认数据正确,保存?",1+48,"确认!")=1 then kcsl1=thisform.kcsl1.Value UPDATE kc SET kcsl = kcsl-kcsl1 WHERE kc.cj=thisform.cj1.Value AND kc.xl=thisform.xl1.Value AND kc.pm
vfp数据类型不对,
IF MESSAGEBOX("请确认数据正确,保存?",1+48,"确认!")=1 then
kcsl1=thisform.kcsl1.Value
UPDATE kc SET kcsl = kcsl-kcsl1 WHERE kc.cj=thisform.cj1.Value AND kc.xl=thisform.xl1.Value AND kc.pm=thisform.pm1.Value AND kc.gg=thisform.gg1.Value AND kc.cfwz=thisform.cfwz1.Value
insert into ck (chrq,cj,xl,pm,gg,cpbh,sj,kcsl,cfwz,dtyf,bz) values ( DATE(),thisform.cj1.Value,thisform.xl1.Value,thisform.pm1.Value,thisform.gg1.Value,thisform.cpbh1.Value,thisform.sj1.Value,thisform.kcsl1.Value,thisform.cfwz1.Value,thisform.dtyf1.Value,thisform.bz1.Value)
vfp数据类型不对,IF MESSAGEBOX("请确认数据正确,保存?",1+48,"确认!")=1 then kcsl1=thisform.kcsl1.Value UPDATE kc SET kcsl = kcsl-kcsl1 WHERE kc.cj=thisform.cj1.Value AND kc.xl=thisform.xl1.Value AND kc.pm
好像是kcsl有问题,你检查一下,这个控件是不是数值型的,最好给它一个默认值0.00