1,077
社区成员
发帖
与我相关
我的任务
分享
--这样肯定行.
update lnr_ps
set lnr_ps.wagetmp = lnr_ps.wagetmp + :cpbf
from lnr_ps , lnr_ff
where lnr_ps.pscode = lnr_ff.pscode and lnr_ff.ffdate = :cpbfym
这样试试:
dec cpbf
string cpbfym
cpbf=10
cpbfym='200801'
string ls_sql
ls_sql = "update lnr_ps set wagetmp = wagetmp + " + string(cpbf) + " where lnr_ps.pscode in (select lnr_ff.pscode from lnr_ff where lnr_ff.ffdate = '" + cpbfym + "'"
EXECUTE IMMEDIATE :Ls_sql USING sqlca;