Hi everyone,

I have the following SP call in method in an exe:
nSQLExec = SQLExec(nConn, "{Call RKR_GetShiftsByMonth (1,2001)}")

And this is the SP:
CREATE PROCEDURE [RKR_GetShiftsByMonth]
@Month as TinyInt = 2,
@Year as TinyInt = 4
AS
Select tshiftstart, tshiftend
From tblOESch_Shifts
Where DatePart(Month,tshiftstart) = @Month and DatePart(Year,tshiftstart) = @Year

The value returned by SQLExec is -1. The nConn value = 1. What am I missing/doing wrong?

Thanks in advance...

Keith