CodeSmith Community
Your Code. Your Way. Faster!

View - Custom Sproc output param support

Latest post 03-31-2007 11:18 AM by nigepj. 1 replies.
  • 03-30-2007 8:22 PM

    • mduray
    • Top 150 Contributor
    • Joined on 03-15-2007
    • Posts 27
    • Points 525

    View - Custom Sproc output param support

     
    The attached code ( based off of netTiers v2.1.0.471 ) enables output params in a custom sprocs for a view.  Before this fix you would get an exception if the sproc didn't have a default value for the output param(s), and the output params wouldn't have been picked up by netTiers. 
     
    Note I am not using Web Services so my changes there aren't tested and it's possible I may have missed something.
     
    Also included in this is a fix in the SqlEntityProviderBase.generated.cst (described here: http://community.codesmithtools.com/forums/thread/23463.aspx)
     
    Hope it helps.
    • Post Points: 35
  • 03-31-2007 11:18 AM In reply to

    • nigepj
    • Not Ranked
    • Joined on 11-27-2005
    • Posts 6
    • Points 90

    Re: View - Custom Sproc output param support

    Hi - thanks for this.

    I think that it works fine as long as the output parameter is not the first one.

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