有关动态运行sql
ls_sql="select count(*) into :ll_count from t_tk005"
EXECUTE IMMEDIATE :ls_sql;
显示ll_count为0;
而直接;select count(*) into :ll_count from t_tk005;
显示为108,是对的
大家指点一下,哪个地方出错了.
问题点数：50、回复次数：6Top
1 楼hygougou（uoguogyh）回复于 2005-06-02 00:50:14 得分 10
参考
http://cpb.cn/disdocument.asp?id=141Top
2 楼princelily（百合）回复于 2005-06-02 07:37:11 得分 5
我紧随狗狗的步伐。哈哈
友情＋帮顶！Top
3 楼workhand（我可憨了...）回复于 2005-06-02 08:35:16 得分 10
ls_sql = "select "+ value_famular
declare c1 dynamic cursor for sqlsa;
prepare sqlsa from :ls_sql;
open dynamic c1;
fetch c1 into :ld_return ;
ll_sqlcode = sqlca.sqlcode
close c1;
if ll_sqlcode <> 0 Then
messagebox(gs_tsxx,"取数出错!")
return 0
End if
return ld_returnTop
4 楼xyqiqi（琪琪）回复于 2005-06-02 10:00:32 得分 10
ls_sql="select count(*) into :ll_count from t_tk005"
不能这样写，如果取多条数据的话用游标。Top
5 楼rightyeah（众妙之门）回复于 2005-06-03 08:16:15 得分 10
ls_sql="select count(*) into :ll_count from t_tk005"
EXECUTE IMMEDIATE :ls_sql;
有楼主这样的写法吗？Dynamic SQL Format 1 只支持立即执行的，没有返回值的语句Top
6 楼j9dai（翔)(DoItNow）回复于 2005-06-03 08:46:48 得分 5
:)Top
