请教为何open后没有返回结果
lzgbn 2009-08-20 05:18:03 DECLARE hep_source DYNAMIC cursor for sqlsa;
str_counttext="SELECT COUNT(*) as row_count FROM EPM_HLJ.C_CONS, EPM_HLJ.C_CUST WHERE ( EPM_HLJ.C_CONS.CUST_ID = EPM_HLJ.C_CUST.CUST_ID ) and (EPM_HLJ.C_CONS.CONS_NO = EPM_HLJ.C_CUST.CUST_NO ) AND EPM_HLJ.C_CONS.ORG_NO LIKE ?"
PREPARE sqlsa FROM :str_counttext USING sqlca3;
//打开游标,取得记录数量
open DYNAMIC hep_source using :str_org_no ;
fetch hep_source into :row_count;
if (sqlca3.sqlcode)<>0 then
goto lab1
end if
请高手指点缺少什么,为什么open后没有返回结果值