LOL! Glad you found a solution to your issue though!

How I wish I had read this about two hours earlier! LOL



Very handy to know.. Thanks!

________________
_____/ Regards,
____/ al

Glad you got it working and that I was of help!

Just letting you know it does indeed work now using SELECT instead of RETURN.

Thanks again to Greg for pointing this out.

Yep, greg nailed it. Even though it is a scalar, you still want to return a recordset, hence the need for a SELECT.

RETURN will exit the code loop immediately. It can return an integer, but that is typically used to show success or failure and isn't what you are looking for in this case.

Philipp,

Using a BO is for a maintenance purpose (All the business code is in the BO, all the connections against SQL server run from a BO to DL)

And the intermediate SP (or execute as.. revert) is for a security purpose: I never expose a SP directly in the AppUser schema.

hi,

thanks. that seems like it could be the problem. i wasnt aware of the use of select instead of return.

i will try changing it when i get back to work tommorow.

I'm wondering if the problem is that you are using Return instead of Select. My understanding is that Return is used to return a status code, while you'd use Select to return a record set, which ExecuteScalar will then retrieve data from. So change:







to







and see if that works. I'm guessing that since you don't select anything, either null or DdNull.Value is being returned from execute scalar.



You might also want to check for conditions like this in code. Something like:

Hi Dustin,

this is my sproc:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spK_KassenAnmeldung]

@HWID VARCHAR(250),

@ComputerName VARCHAR(250)

AS

DECLARE @iKassenId int

SET @iKassenId = ( SELECT TOP 1 ID FROM tbKassen WHERE

HWID = @HWID AND ComputerName = @ComputerName );

IF ( @iKassenId IS NULL )

BEGIN

DECLARE @iKassenNr int;

SET @iKassenNr = ( SELECT count(*) FROM tbKassen );

INSERT INTO tbKassen (Bezeichnung, Zyklus, HWID, ComputerName)

VALUES ('Kasse'+LTRIM(STR(@iKassenNr)) , 0, @HWID, @ComputerName);

SET @iKassenId = SCOPE_IDENTITY();

END

RETURN @iKassenId

Your code looks good. What is in your stored procedure?

I just made a test that comes accross fine using the StrataFrame sample. Here is my SF code:

And here is the alter for my stored procedure:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetCustomerLastName]
-- Add the parameters for the stored procedure here
@cust_pk int = 1
AS
BEGIN
-- Insert statements for procedure here
SELECT cust_LastName FROM Customers WHERE cust_pk = @cust_pk
END