single material into the storehouseADOStoredProc1: commandtext does not return a result set

Procedure TForm11. Button1Click (Sender: TObject);
Var
S2, d1: string;
//t1, t2: int64;
The begin
D1:=Formatdatetime (YYMMDD, Now);
With ADOquery1 do
The begin
The Close;
SQL. The Clear;
SQL. The Add (' select Max (into the warehouse receipt number) as maxno from rj100204_ table into the storehouse where into the warehouse receipt number LIKE ' '%' + d1 + '%' ");
The open;
end;
If ADOquery1. Fieldbyname (' maxno) asstring="' then
The begin
S2: d1 +='01';
The end;
ADOStoredProc1. Close;
ADOStoredProc1. The Parameters. The Clear;
ADOStoredProc1. ProcedureName:='j100404 into warehouse;
ADOStoredProc1. Prepared;
//ADOStoredProc1. The Parameters. Refresh;
ADOStoredProc1. The Parameters. ParamByName (' @ out '). The Value:=' ';
ADOStoredproc1. The Parameters. ParamByName (' @ into the warehouse receipt number). The Value:=s2;
ADOStoredProc1. The Parameters. ParamByName (' @ warehouse entry date). The Value:=formatdatetime (' - dd yyyy - MM, now);
ADOStoredProc1. The Parameters. ParamByName (' @ operator code '). The Value:=ComboBox1. Text;
ADOStoredProc1. The Parameters. ParamByName (' @ remark). Value:=Edit3. Text;
ADOStoredProc1. The Parameters. ParamByName (' @ 'material code). The Value:=ComboBox2. Text;
ADOStoredProc1. The Parameters. ParamByName (' @ material name). The Value:=ComboBox3. Text;
ADOStoredProc1. The Parameters. ParamByName (' @ into the warehouse number '). The Value:=edit1. Text;
ADOStoredproc1. ExecProc;
='display results:' label2. Caption: + ADOStoredproc1. The Parameters. The ParamByName (' @ out '). The Value;

end;

End.

Stored procedure has been even can't do it

CodePudding user response:

Stored procedure has to do with you and see if returned to parameters

CodePudding user response:

First under test data in the database, then the call will know that at the time of call showmessage (); The call is correct,

CodePudding user response:

Chinese variable names, Chinese function names of science
Try using English,
The content post j100404 into the storehouse

CodePudding user response:

Don't understand what is united not..