请问adoquery 或 adodataset 如何取得多个结果集
结果集由存储过程返回P_test as
begin
select '111' as aaa
select '222' as bbb
select '333' as ccc
end我用以下代码不行
adocommand.commandtext:='exec p_test';
adodataset.recordset:=adocommand.execute;
while not adodataset.recordset.eof dob
begin
memo1.lines.add(adodataset.recordset.fields[0].value;
adodataset.recordset.movenext;
end
结果集由存储过程返回P_test as
begin
select '111' as aaa
select '222' as bbb
select '333' as ccc
end我用以下代码不行
adocommand.commandtext:='exec p_test';
adodataset.recordset:=adocommand.execute;
while not adodataset.recordset.eof dob
begin
memo1.lines.add(adodataset.recordset.fields[0].value;
adodataset.recordset.movenext;
end
P_test as
begin
select '111' as aaa
select '222' as bbb
select '333' as ccc
end
P_test as
begin
select '111' as aaa
select '222' as aaa
select '333' as aaa
end
P_test as
begin
select '111' as aaa
union
select '222' as bbb
union
select '333' as ccc
end
这样只能返回一个结果集,我问题的关键是如何取得多个结果集?
一个Query(DataSet)是不能返回多个结果集的.
when 参数=1 then
执行 。
when 参数=2 then
执行。。
when ..........
这样你用那一段就查那一段了。