TMSStoredProc
Posted: Wed 27 Sep 2006 14:48
I create a stored procedue in SQL Server 2000 called "SDAC_FindUser"
and it's code like this :
CREATE PROCEDURE SDAC_FindUser
@PRKEY int
AS
SELECT * FROM Persons
WHERE PRKEY = @PRKEY
RETURN @PRKEY
GO
At the Delphi part, i wrote this code, i used TMSStoredProc component;
with DM1.MSFindUser do
begin
Params.Clear;
Params.CreateParam(ftInteger, 'PRKEY', ptInput);
Params.ParamByName('PRKEY').AsInteger := inpval;
ExecProc;
Returned := Integer(Params.ParamByName('RETURN_VALUE').Value);
ShowMessage(IntToStr(returned));
end;
When i try to run this code compiler gives this error message :
"No Value Given for one or more required parameters."
Please, tell me where is my mistake ? I didn't find my mistake.
Thank you,
and it's code like this :
CREATE PROCEDURE SDAC_FindUser
@PRKEY int
AS
SELECT * FROM Persons
WHERE PRKEY = @PRKEY
RETURN @PRKEY
GO
At the Delphi part, i wrote this code, i used TMSStoredProc component;
with DM1.MSFindUser do
begin
Params.Clear;
Params.CreateParam(ftInteger, 'PRKEY', ptInput);
Params.ParamByName('PRKEY').AsInteger := inpval;
ExecProc;
Returned := Integer(Params.ParamByName('RETURN_VALUE').Value);
ShowMessage(IntToStr(returned));
end;
When i try to run this code compiler gives this error message :
"No Value Given for one or more required parameters."
Please, tell me where is my mistake ? I didn't find my mistake.
Thank you,