Hello all:

I am having this strange problem with Application Blocks.  II posted this yesterday, but it hasn't been posted yet, so I'm reposting.  I have the following stored procedure:

CREATE PROCEDURE GetClientKeyInfo
        @user_id int,
        @lkeyword nvarchar(80)
    AS
    SET NOCOUNT ON
    SELECT
        id,portal_id,module_id,user_id,keyword,key_count,created_date
    FROM ClientKeys WHERE
        user_id=@user_id and keyword=@keyword
GO

When I run the above stored procedure in Query Analyzer (this is SQL 2000 btw), it runs fine.  I receive the record I want and all columns in the select

However, when I use the following code:

      Return CType(SqlHelper.ExecuteReader(ConnectionString, "GetClientKeyInfo", iuser_id, skeyword), IDataReader)


I am only receiving the user_id and the keyword columns.  Could someone tell me what I am doing wrong?  It doesn't make any sense at all to me...

I debugged the core code, and the IDataReader is returning -1 for all columns except the user_id and keyword.

Thanks in advance for your help.