HELP: MS SQL Server and Stored Procedures

I have written several stored procedures and they are all working fine. I am using
MS  SQL Server v6.0.

What I have done is set up the stored procedure component and I have
defined the variable to pass to it (with @). I call it with the following code:

 with MonthlyUpdateProc do
    begin
      Prepare;
      ParamByName('@MonthSelected').AsInteger := MonthSelected;
      ExecProc;
    end;

There is no returned fields so maybe this is the problem. I will give it a test myself.
I suggest you try a simple procedure that doesn't return anything, just get it to
insert a record into a test table.

Hope it helps.

Russell Blackman
russ...@chandos.u-net.com