Adostoredproc.parameters.Parameterbyname(XXXXXX).value 例: function TFData.TransferToPurchase(OrderNo:integer):integer; begin with DataM.ADOCommand do //生成采购单,用通用的TADOCommand Begin CommandText:='TranferToPurchase;1'; Parameters.Clear; Parameters.CreateParameter('@OrderSeq',ftInteger,pdInput,0,0); Parameters.CreateParameter('@ErrorType',ftInteger,pdInputOutput,0,0); Parameters.ParamByName('@OrderSeq').Value:=OrderNo; Execute; Result:=Parameters.ParamByName('@ErrorType').Value; end; end;
例:
function TFData.TransferToPurchase(OrderNo:integer):integer;
begin
with DataM.ADOCommand do //生成采购单,用通用的TADOCommand
Begin
CommandText:='TranferToPurchase;1';
Parameters.Clear;
Parameters.CreateParameter('@OrderSeq',ftInteger,pdInput,0,0);
Parameters.CreateParameter('@ErrorType',ftInteger,pdInputOutput,0,0);
Parameters.ParamByName('@OrderSeq').Value:=OrderNo;
Execute;
Result:=Parameters.ParamByName('@ErrorType').Value;
end;
end;