2,497
社区成员
发帖
与我相关
我的任务
分享
with spExec do
begin
Close;
ProcedureName:='test';
Prepared := True;
Parameters.ParamByName('iUserID').Value := iRow;
//Parameters.CreateParameter('iUserID', ftInteger, pdInput, 4, iRow);
Open;
end;
with spExec do
begin
Close;
ProcedureName:='test';
Prepare;
ParamByName('iUserID').Value := 4; //4还是iRow?不太明白
//Parameters.CreateParameter('iUserID', ftInteger, pdInput, 4, iRow);
Open;
....
end;
//也可以这样写
with spExec do
begin
Close;
ProcedureName:='TestProc';
Parameters.Refresh;
Parameters.ParamByName('@iUserID').Value := iRow;
Open;
end;
with spExec do
begin
Close;
ProcedureName:='test';
Parameters.Clear;
Parameters.CreateParameter('iUserID', ftInteger, pdInput, 4, iRow);
Open;
end;