用游标从access中取数据为什么不行?
//用游标从概念表中取出"概念名"加载到ddlb_1
DECLARE get_cpname CURSOR FOR
SELECT "concept"
FROM "dss_concept"
using sqlca;
messagebox("aaa",string(sqlca.sqlcode))//测试为0
Open get_cpname;//为什么不能打开游标!
messagebox("bbb",string(sqlca.sqlcode))//测试为-1,为什么不能打开?
li_i=1
Fetch get_cpname into :ls_cpname;
messagebox("ccc",string(sqlca.sqlcode))//仍为-1
do while sqlca.sqlcode =0
tab_1.tabpage_conecpt.ddlb_1.Additem(ls_cpname)
li_i++
Fetch get_cpname into :ls_cpname;
loop
close get_cpname;