急!怎样用游标把数据逐项放到pb的datawindow中?

来源:百度知道 编辑:UC知道 时间:2024/06/03 02:49:05
高手帮帮忙啊
改成这样就对了!感谢蝶儿不忙!
string sn,ss,sql
int r
ss=sle_4.text
sql="select Student.sno,ssex,sname,sage,dno from Student inner join Xuanke on Xuanke.sno = Student.sno where cno='"+ss+"'";
dw_1.setsqlselect(sql)
dw_1.retrieve()

sql="select Student.sno,ssex,sname,sage,dno from Student inner join Xuanke on Xuanke.sno = Student.sno where cno='"+ss+"'"
dw_1.setsqlselect(sql)
dw_1.retrieve()

do while sqlca.sqlcode=0
循环的条件错了啊!
应该是WHILE (@@FETCH_STATUS <> -1)