i just change label .text in my code ,after many times change , it is became very blur
this is my app picture
this is my code :
this is my app picture
this is my code :
B4X:
Sub showtotal
Private query3 As String
Private curs3 As Cursor
Private PNUM As String
Private ptotal As String
query3="SELECT SUM(bak) as 'ptotal' FROM cart WHERE bak > 0" 'READ
'HERE get data from sqlit ,after give to label
curs3 = SQL1.ExecQuery(query3)
curs3.Position =0
ptotal=curs3.GetString("ptotal")
Log(PNUM)
'HERE get data from sqlit ,after give to label
query3="SELECT SUM(number) as 'pnum' FROM cart WHERE number > 0"
curs3 = SQL1.ExecQuery(query3)
curs3.Position =0
PNUM=curs3.GetString("pnum")
pnumber.Text=PNUM 'here change the TEXT ON LABEL
Pmoney.Text=ptotal
curs3.Close
End Sub
Last edited: