When I click to delete a record on my grid I get this err msg: ORA-01008: not all variables bound
My SELECT and UPDATE buttons work fine. Any suggestions?
Code:<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT SURPLUS_YR, DIV, SEQ_NO, SURPLUS_TYPE, DECAL_NO, FIELD_DESC, FIELD_MFGR, FIELD_SERIAL_NO, ITEM_CONDITION, SURPLUS_REASON FROM SPAR_DECAL_ITEM WHERE (SURPLUS_YR = :SURPLUS_YR) AND (SEQ_NO = :SEQ_NO) AND (DIV = :DIV)" DeleteCommand="DELETE FROM SPAR_DECAL_ITEM WHERE (SURPLUS_YR = :SURPLUS_YR) AND (DIV = :DIV) AND (SEQ_NO = :SEQ_NO) AND (SURPLUS_TYPE = :SURPLUS_TYPE) AND (DECAL_NO = :DECAL_NO)" UpdateCommand="UPDATE SPAR_DECAL_ITEM SET FIELD_DESC = :FIELD_DESC, FIELD_MFGR = :FIELD_MFGR, FIELD_SERIAL_NO = :FIELD_SERIAL_NO, ITEM_CONDITION = :ITEM_CONDITION, SURPLUS_REASON = :SURPLUS_REASON WHERE (SURPLUS_YR = :SURPLUS_YR) AND (DIV = :DIV) AND (SEQ_NO = :SEQ_NO) AND (SURPLUS_TYPE = :SURPLUS_TYPE) AND (DECAL_NO = :DECAL_NO)"> <SelectParameters> <asp:ControlParameter ControlID="txtYr" Name="SURPLUS_YR" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="txtSeqNo" Name="SEQ_NO" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="txtDiv" Name="DIV" PropertyName="Text" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="SURPLUS_YR" Type="String" /> <asp:Parameter Name="DIV" Type="String" /> <asp:Parameter Name="SEQ_NO" Type="String" /> <asp:Parameter Name="SURPLUS_TYPE" Type="String" /> <asp:Parameter Name="DECAL_NO" Type="Decimal" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="FIELD_DESC" Type="String" /> <asp:Parameter Name="FIELD_MFGR" Type="String" /> <asp:Parameter Name="FIELD_SERIAL_NO" Type="String" /> <asp:Parameter Name="ITEM_CONDITION" Type="String" /> <asp:Parameter Name="SURPLUS_REASON" Type="String" /> <asp:Parameter Name="SURPLUS_YR" Type="String" /> <asp:Parameter Name="DIV" Type="String" /> <asp:Parameter Name="SEQ_NO" Type="String" /> <asp:Parameter Name="SURPLUS_TYPE" Type="String" /> <asp:Parameter Name="DECAL_NO" Type="Decimal" /> </UpdateParameters> </asp:SqlDataSource>




Reply With Quote