Hi, I have this SP: CREATE 1

[loudandclear]

Hi,

I have this SP:


CREATE Procedure sp_LCInsertSelection

(
@DisplayName varchar(100),
@LetterTypeID Int,
@Directory varchar(150),
@TargetGroupID Int,
@AdminID Int )

As

Insert into LCSelection

(DisplayName, LetterTypeID, Directory, TargetGroupID, AdminID)

Values (@DisplayName, @LetterTypeID, @Directory, @TargetGroupID, @AdminID)

Select 0 as ErrorCode, SelectionID = @@Identity

return
GO

For some reason, I cant reach the returned recordset from ADO, it is always closed. But the data gets inserted all right. I am using ADO 2.6.

What sould I do reach the returned RS ?

Chris

 

[swampBoogie]

CREATE Procedure sp_LCInsertSelection

    (
        @DisplayName        varchar(100),
        @LetterTypeID        Int,
        @Directory            varchar(150),
        @TargetGroupID        Int,
        @AdminID            Int    )
As    
    set nocount on
    Insert into LCSelection
      (DisplayName, LetterTypeID, Directory, 
       TargetGroupID, AdminID)
    Values (@DisplayName, @LetterTypeID, @Directory, 
            @TargetGroupID, @AdminID)
    Select 0 as ErrorCode, SelectionID = @@Identity
    return
go

The insert statement causes an empty recordset to be returned unless set nocount on is included

 

[bertrandkis]

I am not sure as to what can be the reason for your record set being empty, but i suspect that the return key word you put after your select statement may be the reason.I hope you understand the implication of using the return keyword in a stored procedure., do not use it if not needed, in your case you are not returning anything so what is the point of using it if the next line that follow signals the end of the stored procedure,Remove the return keyword and try again.