dimanche 24 mai 2015

SUM() Function not Working in sqLite

We have table like this table1

Customer  ItemNumber  Item_Name   Qty   FOCQty    
C1          I1           ABC       10     2
C2          I2           BCA       12     2
C3          I1           ABC       3      3 
C4          I2           BCA       05     1

We need like this

ItemNumber  Item_Name   Qty  FOCQty  
I1            ABC       13     5
I2            BCA       17     3

We tried Like this

tx.executeSql('SELECT ItemNumber,Item_Name,sum(Qunatity) as Qunatity1 ,sum(FOCQty) as FOCQty1  from   toCSV5  Where ItemNumber=?',[this.UpdateItemNumber],SumSuccess,errorCB); 

but it not work for US Please tell me what wrong in my-code

Aucun commentaire:

Enregistrer un commentaire