invalid input syntax for integer in collase( ' ' , 0).

Question

invalid input syntax for integer in collase( ' ' , 0).how correct this error I am waiting Sir

aravinth kandasamy · Answer

Update tbfacilityreceiptitems set itemID = 13886, Batchno =' 1522' ,mfgdate = '10/20/2013 12:00:00 AM', expdate = '10/20/2016 12:00:00 AM', MRP =200.0000, SingleUnitPrice= 158.0000, marginPercentage = 25.00, sellingprice = 184.80, SaletaxID = 34, TaxPercentage = COALESCE('','0')::int , SaleTaxPercentage =COALESCE('' ,'0')::int , SaleTaxType =' ', sellingpricesku = COALESCE ('','0')::int where facreceiptitemid = 2655

Gowtham Rajamanickam · Answer

show me the entire code

Gowtham Rajamanickam · Answer

show me the entire code

aravinth kandasamy · Answer

My code is give below Update tbfacilityreceiptitems set itemID = 13886, Batchno =' 1522' ,mfgdate = '10/20/2013 12:00:00 AM', expdate = '10/20/2016 12:00:00 AM', MRP =200.0000, SingleUnitPrice= 158.0000, marginPercentage = 25.00, sellingprice = 184.80, SaletaxID = 34, TaxPercentage = COALESCE(0,'') , SaleTaxPercentage =COALESCE('' ,0) , SaleTaxType =' ', sellingpricesku = COALESCE ('',0) where facreceiptitemid = 2655 Please rearrange this code

invalid input syntax for integer in collase( ' ' , 0).

Answers (4)