CodeSmith Community
Your Code. Your Way. Faster!

v2.2.0 - Output params not found in custom procs for views

Latest post 06-01-2008 9:22 PM by alan_p_warren. 8 replies.
  • 11-13-2007 10:58 AM

    v2.2.0 - Output params not found in custom procs for views

    Nettiers version 2.2.0 does not generate output parameters for custom stored procedures like the one below.  This procedure declares an output parameter, gets a dataset from a view, and sets the rowcount to the output parameter.  This new version of Nettiers does not find the output parameters and as a result is not included in the generated classes.

    User Mduray wrote a patch for version 2.1, but that patch is now outdated and was not included in the newest release.  If you have a solution please post it here for everyone to use.

     

    CREATE PROCEDURE [dbo].[_ViewFaq_Base_GetByFaqId]

    @FaqId INT , @OutputRowCount INT OUTPUT

    AS

    SELECT

    FaqId, Topic, Solution

    FROM

    ViewFaq_Base

    WHERE FaqId = @FaqId

    SET @OutputRowCount = @@RowCount

    • Post Points: 35
  • 02-02-2008 3:30 AM In reply to

    • halex
    • Top 500 Contributor
    • Joined on 12-06-2006
    • Posts 14
    • Points 250

    Re: v2.2.0 - Output params not found in custom procs for views

    I also need this. Does anyone have this solution/bug fix? 

    • Post Points: 5
  • 02-02-2008 3:43 AM In reply to

    • halex
    • Top 500 Contributor
    • Joined on 12-06-2006
    • Posts 14
    • Points 250

    Re: v2.2.0 - Output params not found in custom procs for views

    PROBLEM:

    Custom Stored Procedure for View does not return OUTPUT parameter eventhough it is specified. 

    Someone publish a patch for this problem in old version of netTiers 2.1.0.471 here http://community.codesmithtools.com/forums/p/6041/23465.aspx#23465

    But it is not OK for version 2.2.0 and in this version the same problem exists and there is no patch/or I can't find it!

    Does anybody have a solution for this problem? 

     

    • Post Points: 5
  • 02-02-2008 4:31 AM In reply to

    • halex
    • Top 500 Contributor
    • Joined on 12-06-2006
    • Posts 14
    • Points 250

    Re: v2.2.0 - Output params not found in custom procs for views

    I used latest 2.2.0 build and problem still exists. 

    • Post Points: 35
  • 05-15-2008 5:54 PM In reply to

    • blake05
    • Top 25 Contributor
    • Joined on 04-03-2008
    • Wisconsin
    • Posts 333
    • Points 5,930

    Re: v2.2.0 - Output params not found in custom procs for views

    Hello,

    I just wanted to let you know, that we are looking into this bug.

    Have a nice day

    -Blake

    Blake Niemyjski

    CodeSmith Tools, LLC Support Specialist

    Blog: http://windowscoding.com/blogs/blake/

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 35
  • 05-22-2008 12:31 PM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 332
    • Points 8,380

    Re: v2.2.0 - Output params not found in custom procs for views

    Fixed in Rev 720.  As a note, SVN reposirory has changed.  Go to http://nettiers.googlecode.com for instructions.

    jeff

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 35
  • 06-01-2008 6:15 PM In reply to

    Re: v2.2.0 - Output params not found in custom procs for views

    Hi

    I have dowloaded NetTiers 2.2.0 from the link provided, but it is an earlier revision than 720, and does not fix the output parameter problem. Can anyone please provide a link to a NetTiers download that includes a fix for this problem?

    Thanks

    Alan

    • Post Points: 35
  • 06-01-2008 7:31 PM In reply to

    • SuperJeffe
    • Top 25 Contributor
    • Joined on 05-05-2006
    • Tulsa, Ok
    • Posts 332
    • Points 8,380

    Re: v2.2.0 - Output params not found in custom procs for views

    http://www.nettiers.com/Download.ashx

    You can get it from the Nightly Builds or the Google Code repository.

    jeff

     

    ----------------------------------------------------------------------
     Member of the .NetTiers team | Visit http://www.nettiers.com
    ----------------------------------------------------------------------

    • Post Points: 35
  • 06-01-2008 9:22 PM In reply to

    Re: v2.2.0 - Output params not found in custom procs for views

    File nettiers-2.3-r720.zip from the Nightly Builds folder contains the fix I require. Thank you.

    • Post Points: 5
Page 1 of 1 (9 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems