problem on adding or removing a parameter in sp using DAAB, plz help and guide me. RRS feed

  • Question

  • Hi,

    thanks for your attention and time.

    I am using DAAB with stored procedures. A stored procedure is  called by different functions where no. of parameters passed by functions may differ. For example stored procedure p_get_product it returns all products or one product.

    Initially when I use it for getting all products in function, I was not required to pass product id so I just passed @Mode (which means when  @Mode=1, I will check with if-else and a special part of code in sp will be executed) but later when I need to pass productID in second function, first part start throwning error that no of paramerters are not same.

    It is a problem as we are working in team, when ever someone add a new parameter previous no of parameters do not remain same and consequently there appears errors in previous work.

    How this should be managed, please guide and help.


    <input id="gwProxy" type="hidden"><!-- Session data--></input> <input id="jsProxy" onclick="jsCall();" type="hidden" />
    Friday, February 12, 2010 5:45 AM