Android Question what causes this in my table

[Makumbi]

Please help i have deleted data and then inserted new data in my table called balances but i can see these wierd figures in the balance section please help

 

[KMatle]

How is the column defined and what EXACTLY did you insert? I assume it's SQLite: It accepts if you insert 1e2 instead of 100. It's called "Exponent". Normal in math. You can change it to TEXT so it will accept any value you insert "like it is".

 

[Mahares]

but i can see these wierd figures in the balance section

It could also be due to the width of the column not being wide enough. Table class has a method to allow you to manually assign the width or it can be done automatically using one of these respectively:
Table2.SetColumnsWidths(Array As Int(50dip, 200dip, etc....
Table2.LoadSQLiteDB3(.........

 

[klaus]

What is the data type in the database?
The problem is with REAL data type.
SQLite returns REAL numbers bigger than 999999 with scientific notation like:
123456 > 123456
1234567 > 1.23457e6
12345678 > 1.23457e7
As KMatle suggested, you should use a TEXT data type.
With TEXT or INTEGER data type the display is like you expect it.

With REAL

With TEXT or INTEGER

@Mahares
Makumbi is not using the Table class but a HTML table in a WebView.