CodeSmith Community
Your Code. Your Way. Faster!

CS_Default extended property values for ParameterSchema objects are not set

Latest post 03-02-2008 11:21 PM by ejsmith. 2 replies.
  • 02-13-2006 4:04 PM

    • rogerr
    • Top 150 Contributor
    • Joined on 08-05-2005
    • Posts 25
    • Points 540

    CS_Default extended property values for ParameterSchema objects are not set

    Is there any way to access the default value of a stored procedure parameter, if it has any?

    ColumnSchema and ParameterSchema both derive from DataObjectBase, and expose the ExtendedProperties collection, which in the case of columns, contains a property CS_Default that contains the column's default value.  But, I find that extended properties for a parameter object contain a CS_Default property, but the value is never set, even for parameters with defaults.

    Is this a known problem or is there some other way to get this info?

    Thanks

    • Post Points: 35
  • 02-20-2008 5:24 AM In reply to

    • erb
    • Not Ranked
    • Joined on 12-05-2007
    • Posts 2
    • Points 40

    Re: CS_Default extended property values for ParameterSchema objects are not set

    I run CodeSmith 4.1.2 and I also notice that CS_Default is not showing for procedure parameters. Obviously this hasn't been resolved yet in version 4.1.2.

    Is there a work around?

    Regards

    Ernst Breivik

    • Post Points: 35
  • 03-02-2008 11:21 PM In reply to

    • ejsmith
    • Top 10 Contributor
    • Joined on 12-27-2002
    • Dallas, TX USA
    • Posts 2,189
    • Points 922,175

    Re: CS_Default extended property values for ParameterSchema objects are not set

    This issue is fixed in the latest (4.1.3) maintenance release. 

    Eric J. Smith
    CodeSmith Tools, LLC
    Chief Software Architect

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