Question

请帮我看看是哪里错了？谢谢谢谢（pb）

string sn,c
select cno into :c from Shouke where tno=:sle_5.text;
select sno into :sn from Xuanke where cno=:c;

string s="select sno,ssex,sname,sage,dno from Student where sno=:sn"
dw_1.setsqlselect(s)
dw_1.retrieve()
因为c是主语言变量，却在sql server语句中···

Answer 1

select cno into :c from Shouke where tno=:sle_5.text;

c前面为什么有冒号

那要用字符串拼接 且值前后要有单引号

不太了解pb 不知道用什么语法拼接

string s="select sno,ssex,sname,sage,dno from Student where sno='"+:sn+"'"