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
      ParamByName('@MonthSelected').AsInteger := MonthSelected;

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