方法1 :adodataset
with ADODataSet1 do
begin
Connection:=ADOConnection1;
CommandType:=cmdText;
CommandText:='{call modi_process('+inttostr(processid)+',''0701'')}';
showmessage(CommandText);
Open;
end;方法2:adostoredproc
with ADOStoredProc1 do
begin
Connection := ADOConnection1;
Parameters.Clear;
ProcedureName:= 'modi_process';
Parameters.CreateParameter('processid_in',ftinteger,pdInput,10,processid);
Parameters.CreateParameter('node_code_in',ftstring,pdInput,5,'0701');
Open;
end;
出错信息相同,当前提供程序不支持从单一执行返回多个记录集
with ADODataSet1 do
begin
Connection:=ADOConnection1;
CommandType:=cmdText;
CommandText:='{call modi_process('+inttostr(processid)+',''0701'')}';
showmessage(CommandText);
Open;
end;方法2:adostoredproc
with ADOStoredProc1 do
begin
Connection := ADOConnection1;
Parameters.Clear;
ProcedureName:= 'modi_process';
Parameters.CreateParameter('processid_in',ftinteger,pdInput,10,processid);
Parameters.CreateParameter('node_code_in',ftstring,pdInput,5,'0701');
Open;
end;
出错信息相同,当前提供程序不支持从单一执行返回多个记录集
Open;换成
ExecProc;