with adostoredproc1 do
beigin
Close;
Procedurename := 'USP_UPSTOCKIMPORT';
Parameters.ParamByName('LNO').Value := '0001';
Parameters.ParamByName('OPERATER').Value := 'CurrUser';
open;
end;
beigin
Close;
Procedurename := 'USP_UPSTOCKIMPORT';
Parameters.ParamByName('LNO').Value := '0001';
Parameters.ParamByName('OPERATER').Value := 'CurrUser';
open;
end;
Close;
Procedurename := 'USP_UPSTOCKIMPORT';
Parameters.paramers[i].Value := '0001';open;
在查询分析器中已经调用成功,参数格式如下:
CREATE PROCEDURE sp_InOutStock(
@BeginDate varchar(20) = '2002-01-01' ,
@EndDate varchar(20) ='####',
@StorageId varchar(20) ='%',
@BusiId varchar(20) ='%',
@MerId varchar(20) ='%' ,
@MerSortId varchar(20) = '%',
@OrderBy varchar(20) ='ASC' )AS......
请各位大虾帮忙!!!