Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1910
Procedure or function X has too many arguments specified
posted

I'm getting an error when trying to insert a parent and/or child record. The error says "Procedure or function usp_ins_Chart_Review_Claim has too many arguments specified." I've checked the stored procedures and they both have the same number of parameters that are in their section.

Here is what the datasource code looks like:

<ig:WebHierarchicalDataSource ID="WHDS_Claims_and_Diags" runat="server">

<DataViews>

<ig:DataView ID="dsClaims_DefaultView" DataMember="DefaultView" DataSourceID="dsClaims" />

<ig:DataView ID="dsDiags_DefaultView" DataMember="DefaultView" DataSourceID="dsDiags" />

DataViews>

<DataRelations>

<ig:DataRelation ChildColumns="Original_Claim_ID" ChildDataViewID="dsDiags_DefaultView" ParentColumns="Original_Claim_ID" ParentDataViewID="dsClaims_DefaultView" />

DataRelations>

ig:WebHierarchicalDataSource>

<asp:SqlDataSource ID="dsClaims" runat="server" ConnectionString="<%$ ConnectionStrings:cs_CHP_EDPS %>" InsertCommand="usp_ins_Chart_Review_Claim" InsertCommandType="StoredProcedure" OnInserting="dsClaims_Inserting" SelectCommand="usp_get_Chart_Review_Claims_in_Prev_Year" SelectCommandType="StoredProcedure">

<InsertParameters>

<asp:Parameter Name="Member_ID" Type="String" />

<asp:Parameter DbType="Date" Name="Start_Date" />

<asp:Parameter DbType="Date" Name="End_Date" />

<asp:Parameter Name="User_Name" Type="String" />

InsertParameters>

<SelectParameters>

<asp:QueryStringParameter Name="Member_ID" QueryStringField="Member_ID" Type="String" />

<asp:QueryStringParameter Name="HCC" QueryStringField="HCC" Type="Int32" />

SelectParameters>

asp:SqlDataSource>

<asp:SqlDataSource ID="dsDiags" runat="server" ConnectionString="<%$ ConnectionStrings:cs_CHP_EDPS %>" DeleteCommand="usp_del_Chart_Review_Diag" DeleteCommandType="StoredProcedure" OnDeleting="dsDiags_Deleting" InsertCommand="usp_ins_Chart_Review_Diag" InsertCommandType="StoredProcedure" OnInserting="dsDiags_Inserting" SelectCommand="usp_get_Chart_Review_Claim_Diags" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:QueryStringParameter Name="Member_ID" QueryStringField="Member_ID" Type="String" />

SelectParameters>

<DeleteParameters>

<asp:Parameter Name="Row_ID" Type="Int32" />

<asp:Parameter Name="User_Name" Type="String" />

DeleteParameters>

<InsertParameters>

<asp:Parameter Name="Claim_ID" Type="String" />

<asp:Parameter Name="Diag" Type="String" />

<asp:Parameter Name="User_Name" Type="String" />

InsertParameters>

asp:SqlDataSource>

Parents Reply Children