Android Question Problem class module table.bas currency

puang · Feb 20, 2019

I have sqlite database with table and field.
Example :
nametable : SalesTables
field1 : |FieldId| number|
field2 : |FieldBookName| text|
field3 : |FieldPrice| currency|

| Id|BookName|Price |
|1 |abc |$10.000|

I build apk database to listview ( but use it class module Table.bas )

Problem : Table1 in Layout
| Id|BookName|Price |
|1 |abc |10000|

Expectation : Table1 in Layout
| Id|BookName|Price |
|1 |abc |$10.000 |

Erel · Feb 20, 2019

You should use B4XTable for this. You can set a custom B4XFormatter that includes the $ sign.

klaus · Feb 20, 2019

It is not possible to do it directly.
It could be done after having loaded the database and then adding the $ sign with UpdateCell.

Or as a workaround you could do this:
Expectation : Table1 in Layout
| Id|BookName|Price $|
|1 |abc |10.000 |

puang · Feb 20, 2019

klaus said:
It is not possible to do it directly.
It could be done after having loaded the database and then adding the $ sign with UpdateCell.

Or as a workaround you could do this:
Expectation : Table1 in Layout
| Id|BookName|Price $|
|1 |abc |10.000 |

the way (code) 10000 to 10.000
if 100 = 100
if 1000 = 1.000
if 10000 = 10.000
if 100000 = 100.000
if 1000000 = 1.000.000

klaus · Feb 20, 2019

You need to modify the cells after having filled the Table:

B4X:

Private col, row As Int
col = 2  'the index of the column to modify
For row = 0 To Table2.NumberOfRows - 1
    Private Value As Double
    Private sValue As String
    Value = Table2.GetValue(col, row)  'gets the cell value and transforms it into a String
    sValue = "$ " & NumberFormat2(Value, 1, 0, 0, True)   'formats the value into a string
    sValue = sValue.Replace(",", ".")  'replaces the commas by dots.
    Table2.SetValue(col, row, sValue)  'sets the new value in the cell
Next

Android Question Problem class module table.bas currency

puang

Member

Erel

B4X founder

klaus

Expert

puang

Member

klaus

Expert

Similar Threads

Android Question Problem class module table.bas currency

puang

Member

Erel

B4X founder

klaus

Expert

puang

Member

klaus

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency