请问如何在PB执行Store Procedure?
请问如何在PB执行Store Procedure? 以下是我的程序代码,执行后没有结果产生。
integer li_i
string ls_itemno,ls_storeno,ls_today
ls_today = string(today(),'yyyymmdd') //预交日的where argument
SetPointer(HourGlass!)
IF dw_1.rowcount() = 0 THEN
MESSAGEBOX(gs_msg,'无数据显示!')
sle_1.setfocus()
RETURN
ELSE
FOR li_i=1 TO dw_1.rowcount()
ls_itemno = dw_1.GetItemString (li_i, "td004") //品号
ls_storeno= dw_1.GetItemString (li_i, "cmsmc_mc001") //库别代号
DECLARE proc1 PROCEDURE FOR SP_INVMC_PRE
@itemno = :ls_itemno,
@storeno = :ls_storeno,
@today = :ls_today;
EXECUTE proc1;
NEXT
dw_1.settransobject(SQLCA)
dw_1.retrieve()
END IF
SetPointer(arrow!)