Android Question SQLLite return science number

ttsolution

Member
Licensed User
Longtime User
Dear all,
I select price from SQLLite as follow query

mPrice=Main.SQL1.ExecQuerySingleResult("Select ifnull(PriceWithVAT,0) as PriceWithVAT from ProductPrice Where ItemCode='" & P.ItemCode & "'")

result : mPrice= 2.04039E7 (but the actual value is 20403831.8)

When I show the value to EditText, it is 2.04039E7 rather than 20403831.8

Many thanks for any help

Jonh,
 
Sort by date Sort by votes
K

keirS

Well-Known Member
Licensed User
Longtime User
Use the NumberFormat function to format the number for display in the Editext.
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
Another alternative to Erel and keirS good advice is to use the SUBSTR function like this without having to reformat the result:
B4X: 
Dim mPrice As String
mPrice=Main.SQL1.ExecQuerySingleResult("Select ifnull(substr(PriceWithVAT,1),0) " _
& "from ProductPrice Where ItemCode='" & P.ItemCode & "'")
Log(mPrice)
 
Upvote 0
E

edgar_ortiz

Active Member
Licensed User
Longtime User
You can try:

mPrice=Main.SQL1.ExecQuerySingleResult("Select cast(ifnull(PriceWithVAT,0) as decimal(10,2)) as PriceWithVAT from ProductPrice Where ItemCode='" & P.ItemCode & "'")

Regards

Edgar
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Access to field type in SqlLite database
Replies
8
Views
1K
Paolo Pini
  • Article
B4A Library Financial Functions
Replies
0
Views
1K
Col
  • Question
Android Question [ANSWERED] Label.text in a Scrollview problem
Replies
3
Views
738
LucaMs
M
  • Question
Android Question how to insert return values from asp.net webpage into sqllite database
Replies
3
Views
1K
Erel
A
  • Question
SQLLite to ListView and selection
Replies
5
Views
2K
Ennesima77
E
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…