我还是不明白NextRecordset()中所传递的RecordsAffected参数的用处是什么。
还有当
use pubs
go
create proc Mypro
as
begin
--update,insert在这里插入后,就读不了后面的表了
SELECT * FROM AUTHORS
SELECT * FROM JOBS
end
谢谢!
use pubs
go
create proc Mypro
as
begin
SELECT * FROM AUTHORS
SELECT * FROM JOBS
end
procedure TForm1.FormCreate(Sender: TObject);
VAR I:INTEGER;
begin
try
I:=2;
MyQuery.sql.add('exec mypro');
MYQUERY.Active:=TRUE;
MYQUERY.RecordSet := MYQUERY.NextRecordset(I);//读第二个表
while not myquery.Eof do
begin
memo1.lines.add(myquery.FieldByName('job_desc').asstring);
myquery.Next;
end;
finally