>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
After it fails, execute the AError() to determine what the remote error was.
=aerror(laerror)
display memory like laerror
What is/are the error(s)?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao