Hello,

I am creating my own module and have added my database and stored procedures to update, delete, insert, select and they all work fine when I call them from my BLL.

Here is the stored procedure, when I execute it it works fine.

ALTER Procedure BrowserInfo2_IPCount

@IID int OUT

SET @IID =

(Select COUNT(IPAddress)

from Creations_BrowserInfo2)

RETURN @IID

The problem I am having is retrieving the value of @IID in my BLL.

Here is my BLL

Public Shared Function BrowserInfo2_IPCount() As Integer

Dim cnt As Integer

DataProvider.Instance().ExecuteScalar("BrowserInfo2_IPCount", cnt)

BrowserInfo2_IPCount = cnt

End Function

I always get a 0.

Any help would be very appreciated.

Dan5150

Thanks Brian!

I tried both ways but still get a 0. When I execute the Stored Procedure It ask me for an input for @IID, if I use default I get a zero, if I use any number I get the correct Return_Value.

In my BLL when I create the parameter and add a param.value, I always get the same value I entered back. If I don't add a value the procedure uses default which produces a 0. I have changed my stored procedure to:

ALTER Procedure BrowserInfo2_IPCount

@IID int OUTPUT

SET @IID = 12

RETURN @IID

For testing purposes. And changed my function to:

Dan5150

Thanks Allot coolwave6!

That worked great.

My headache is over!

It seems that if you add a RETURN in the stored procedure, then execute it by scalar it returns a 0.

Dan5150