MS SQL Server Stored Procedures

[Guest_imported]

Hi

I wish to access a stored procedure using ADO in Delphi 6. The stored procedure (sp_getschedule) is written in MS SQL Server and takes one input parameter called @ScheduleDate.

I wrote the following code segment in Delphi to execute the stored procedure:

with frmMain.ADOStoredProc do begin

Active := False;
Parameters.ParamByName('@ScheduleDate').Value := Date;
ProcedureName := 'sp_getschedule';
Open;
Active := True;

end;

When executed, Delphi returns the error:

ADOStoredProc: Parameter '@ScheduleDate' not found

Any suggestions would be greatly appreciated.

-Andrew

 

[svanels]

Try

1) Set the Procedure name before you assign values to the parameter

and

2) ParamByName('ScheduleDate').asDate := Date;


or

3) ParamByName('ScheduleDate').value := Date;


S. van Els
SAvanEls@cq-link.sr