1 Replies - 255 Views - Last Post: 11 November 2017 - 09:36 PM Rate Topic: -----

#1 [email protected]  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 33
  • Joined: 16-May 17

Has too many arguments specified. Please help me

Posted 11 November 2017 - 08:33 PM

Procedure or function P_UpdatePurchaseInv_test has too many arguments specified.

ALTER PROC [dbo].[P_DeleteForUpdatePurInvDet]
--Purchase Invoice Details       12 pic(13pic active)
  [email protected]   int ,        
[email protected]  varchar(255),      
@purinvdt  date,      
@invno   varchar(255),       
@invdt   date,       
@nrr   varchar(200),       
@partyIDpur  int,      
@invtypidpur int,      
@tottaxblamt decimal(18, 2),      
@nettaxamt  decimal(18, 2),      
@invamt   decimal(18, 2),      
@totalcgst  decimal(18, 2),      
@totalsgst  decimal(18, 2),      
@totaligst  decimal(18, 2),      
-------------------------------------      
--Purchase Invoice Sub Details --------16pic (18pic) active
@slno   int,        
@ItemIDpur  int,     
@ItemhsnID  int,      
@PDQty   int,        
@PDMRP   decimal(18, 2),        
@PDRate   decimal(18, 2),         
@PDdis   decimal(18, 2),         
@pdcgst   decimal(18, 2),         
@cgstamt  decimal(18, 2),         
@pdsgst   decimal(18, 2),         
@sgstamt  decimal(18, 2),         
@pdigst   decimal(18, 2),         
@igstamt  decimal(18, 2),         
@TaxableAmt  decimal(18, 2),         
@totaltaxamt decimal(18, 2),         
@PDAmount  decimal(18, 2),   
[email protected] date,     
-------STOCK----------- UPDATE------------        
@MRP decimal(7, 2),          
@prate decimal(7, 2),
@purinvid varchar(50),------------------------- Pass 
@itemid  int  --------------------------------- Pass
  as
 
  begin
  delete from TBL_pur_invdet where [email protected]
  end
  
  begin
  insert into TBL_pur_invdet(purinvid,slno,ItemIDpur,PDQty,PDMRP,PDRate,PDdis,pdcgst,cgstamt,pdsgst,sgstamt,pdigst,igstamt,TaxableAmt,totaltaxamt,PDAmount,itemhsnid,purdate)          
  values(@purinvid,@slno,@ItemIDpur,@PDQty,@PDMRP,@PDRate,@PDdis,@pdcgst,@cgstamt,@pdsgst,@sgstamt,@pdigst,@igstamt,@TaxableAmt,@totaltaxamt,@PDAmount,@ItemhsnID,@invdt)          
  end
  
  begin
  update tbl_item set  [email protected],[email protected] where [email protected]    
  end
  
  begin
  update tbl_pur_inv set [email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected],[email protected]
  where [email protected] 
  end



Public Function EditPurchaseinv() As DataSet ' Edit Purchase Invoice ------------------------------------------------------------------
            Dim db As New DBAccess
            db.AddParameter("@purinvid", purinvid)
            db.AddParameter("@purinvdt", purinvdt)
            db.AddParameter("@invno", invno)
            db.AddParameter("@invdt", invdt)
            db.AddParameter("@nrr", nrr)
            db.AddParameter("@partyIDpur", partyIDpur)
            db.AddParameter("@invtypidpur", invtypidpur)
            db.AddParameter("@tottaxblamt", tottaxblamt)
            db.AddParameter("@nettaxamt", nettaxamt)
            db.AddParameter("@invamt", invamt)
            db.AddParameter("@totalcgst", totalcgst)
            db.AddParameter("@totalsgst", totalsgst)
            db.AddParameter("@totaligst", totaligst)
 
            '------------------------------------------
 
            'db.AddParameter("@purinvid", purinvid)
            db.AddParameter("@slno", slno)
            db.AddParameter("@ItemIDpur", ItemIDpur)
            db.AddParameter("@ItemhsnID", ItemhsnID)
            db.AddParameter("@PDQty", PDQty)
            db.AddParameter("@PDMRP", PDMRP)
            db.AddParameter("@PDRate", PDRate)
            db.AddParameter("@PDdis", PDdis)
            db.AddParameter("@pdcgst", pdcgst)
            db.AddParameter("@cgstamt", cgstamt)
            db.AddParameter("@pdsgst", pdsgst)
            db.AddParameter("@sgstamt", sgstamt)
            db.AddParameter("@pdigst", pdigst)
            db.AddParameter("@igstamt", igstamt)
            db.AddParameter("@TaxableAmt", TaxableAmt)
            db.AddParameter("@totaltaxamt", totaltaxamt)
            db.AddParameter("@PDAmount", PDAmount)
            db.AddParameter("@purdate", purdate)
            '---------------STOCK UPDATE----------------------
            db.AddParameter("@itemid", itmid)
            db.AddParameter("@MRP", MRP)
            db.AddParameter("@prate", prate)
            'db.AddParameter("@QTY", QTY)
 
            Return db.ExecuteDataSet("P_UpdatePurchaseInv_test") 'P_UpdatePurchaseInv_test       P_UpdatePurchaseInv
        End Function

This post has been edited by [email protected]: 11 November 2017 - 08:34 PM


Is This A Good Question/Topic? 0
  • +

Replies To: Has too many arguments specified. Please help me

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13666
  • View blog
  • Posts: 54,541
  • Joined: 12-June 08

Re: Has too many arguments specified. Please help me

Posted 11 November 2017 - 09:36 PM

It should be pretty straight forward. Make sure all the parameters added match up to the parameters needed.. taking into account which ever you commented out.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1