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
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/02 21:49:35
![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](/uploads/image/z/14762545-25-5.jpg?t=vfp%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E4%B8%8D%E5%AF%B9%2CIF+MESSAGEBOX%28%26quot%3B%E8%AF%B7%E7%A1%AE%E8%AE%A4%E6%95%B0%E6%8D%AE%E6%AD%A3%E7%A1%AE%2C%E4%BF%9D%E5%AD%98%3F%26quot%3B%2C1%2B48%2C%26quot%3B%E7%A1%AE%E8%AE%A4%21%26quot%3B%29%3D1+then++++kcsl1%3Dthisform.kcsl1.Value++++++++UPDATE+kc+SET+kcsl+%3D+kcsl-kcsl1++WHERE+kc.cj%3Dthisform.cj1.Value+AND+kc.xl%3Dthisform.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
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