I have a StoredProcedure that evaluates the table and if certain conditions are met, completes an Update.  When I run it in the VS2005 Server Explorer it behaves exactly as designed (only updates the table if the conditions are met) and returns "@RETURN_VALUE = 0"(conditions not met) or "@RETURN_VALUE = 1" (conditions met) exactly as I want.  However, when I try to call it from my application it , always updates the table, no matter if the conditions are met or not.  I also obviously don't understand how to pass the @RETURN_VALUE back thru the SqlDataProvider, DataProvider, and Controller file to display to the user the messages I want to. I always ge thte failure message with a successful update.  Is there a tutorial on or example on using @RETURN_VALUE in the DAL, BLL, or anyone willing to give me a hand?

The Stored Procedure (this Works in server Explorer):

ALTER PROCEDURE dbo.[PSLPD_OverTime_SignUp48Count]

(

@ID int,

@ModuleID int,

@Shift nvarchar(50),

@SignedUpUser nvarchar(50),

@CreatedByUser nvarchar(250),

@DateSignedUp datetime

)

AS

DECLARE @48Count Int

SELECT @48Count = COUNT(*)

FROM PSLPD_OverTime

WHERE (ModuleID = @ModuleID) AND (SignedUpUser = @SignedUpUser) AND (Shift = @Shift) AND (CreatedByUser = @CreatedByUser)

AND (DateofShift >= GETDATE()) AND (DATEDIFF(minute, DateEntered, GETDATE()) <= 2880)

UPDATE PSLPD_OverTime

SET SignedUpUser =@SignedUpUser, DateSignedUp = @DateSignedUp

WHERE ID = @ID AND (@48Count < 2)

RETURN @@rowcount

I will post whatever code is needed...

John

---

John

When declaring the function in sqldataprovider, one of the parameter usedin the function definition used to pass back the return value should be declared as "byRef".