-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
SUM or TOTAL in sql are int or float ?
- Thread starter gapi
- Start date
- Similar Threads Similar Threads
this is my query:
If I query single field (col10) it return value with commas, in SUM case not :BangHead:
B4X:
MainQuery = "SELECT TOTAL(scadenze.col10) as totFattura, ditte.col2 As NOMEDITTA, scadenze.col4 " & _
" FROM scadenze " & _
" INNER JOIN ditte ON scadenze.col4= ditte.col1" & _
" WHERE scadenze.col3=" & QUOTE & ccode & QUOTE & _
" GROUP BY NOMEDITTA"If I query single field (col10) it return value with commas, in SUM case not :BangHead:
Upvote
0
The result of total(x) should be float. See this link: SQLite Query Language: Aggregate Functions
Upvote
0