B4J Question how to sum all the values of a map in b4x

[juangtju]

Good friends, I'm trying to add the values I have from a map that I bring from a mysql query with jrcd2 but I still can't find the function, if someone can help me I would be grateful

 

[Erel]

Dim total As Int
For Each value As Int In YourMap.Values
 total = total + value
Next

 

[juangtju]

Thanks Erel, however the problem I have is that the map that I need to add is the one that brings me all the information from the database and has many values, I think the most logical thing would be that after the JRDC brings me the map complete, I made a separate one only with the values that I want sum, is it correct? since I am trying to sum the values from the database but it gives me error

sql.sumvuelto = SELECT SUM(vuelto) * FROM osi.vuelto WHERE `codiclie` LIKE ?

If I do it in another program that handles the queries, it does handle it for me, but I don't know if the JRDC can handle those summation queries.

 

[juangtju]

It is a way of adding it directly from the ide, however I managed to bring the sum with a query, thank you erel, for such a prompt response ?

sql.sumvuelto = SELECT SUM(vuelto) as total FROM osi.vuelto WHERE `codiclie` LIKE ? AND `dateused` IS NULL
this is the query what i use for this purpose