730
社区成员
- 主页
PB中执行下面的SQL不成功,请高手来指点一下
UPDATE SK_XFJLB
SET JZstatus = :li_flag
WHERE (XF_PH in ( :as_phlist )AND XF_JZBZ='否' ) ;
IF SQLCA.SQLCODE = 0 THEN
COMMIT USING SQLCA;
ELSE
ROLLBACK USING SQLCA;
Messagebox('','失败.')
END IF
as_phlist 参数为(0001,0002,0003)
如果as_phlist为 0001是可以成功的,
如果是多个以上,则不能成功了
SET JZstatus = :li_flag
WHERE (XF_PH in ( :as_phlist )AND XF_JZBZ='否' ) ;
IF SQLCA.SQLCODE = 0 THEN
COMMIT USING SQLCA;
ELSE
ROLLBACK USING SQLCA;
Messagebox('','失败.')
END IF
as_phlist 参数为(0001,0002,0003)
如果as_phlist为 0001是可以成功的,
如果是多个以上,则不能成功了
...全文
请发表友善的回复…
发表回复
fengemail8 2010-07-05
xys_777 谢谢提醒,不过XF_PH 位数是固定的,不会存在冲突
永生天地 2010-07-05
但是建议改成这样
UPDATE SK_XFJLB
SET JZstatus = :li_flag
WHERE (CHARINDEX(','+XF_PH+',',','+:as_phlist+',') >0
AND XF_JZBZ='否'
) ;
UPDATE SK_XFJLB
SET JZstatus = :li_flag
WHERE (CHARINDEX(','+XF_PH+',',','+:as_phlist+',') >0
AND XF_JZBZ='否'
) ;
永生天地 2010-07-05
gx .
fengemail8 2010-07-05
UPDATE SK_XFJLB
SET JZstatus = :li_flag
WHERE (CHARINDEX(XF_PH,:as_phlist) >0
AND XF_JZBZ='否'
) ;
自已解决
SET JZstatus = :li_flag
WHERE (CHARINDEX(XF_PH,:as_phlist) >0
AND XF_JZBZ='否'
) ;
自已解决
fengemail8 2010-07-05
jimwoo 谢谢,不是这样的
jimwoo 2010-07-05
试试这样
String ls_sql, as_phlist
Int li_flag
as_phlist = "'0001','0002','0003'"
ls_sql = "UPDATE SK_XFJLB SET JZstatus = " + String(li_flag) +&
" WHERE XF_PH in (" + as_phlist + ") AND XF_JZBZ='否' "
EXECUTE IMMEDIATE :ls_sql;fengemail8 2010-07-05
换句话说,在PB中更新多条记录是怎么写的