samedi 29 août 2015

Sum Sqlite Problems

I want to get the sum of the amount when the status is equal to "G" but I value returned is only the first data.

CODE:

impVentas = bd2.rawQuery("SELECT ROUND(SUM(MONTO),2) FROM CUERPO WHERE ESTADO='G' AND ENCA_ID="+idFact, null);

This code returns only the first data CUERPO and I need all the data.

Aucun commentaire:

Enregistrer un commentaire