Currency in SQLite?

[Emile_Schwarz]

Misunderstandings…

Xojo provides Currency.

I now Write the values as Currency (to .sqlite) and Read them as Currency (in the ListBox).

The code is simple:
Write to .sqlite:
row.Column("SRU").CurrencyValue = aLine.NthField(Chr(9),3).ToDouble

Display to DesktopListBox:
LB.CellTextAt(LB.LastAddedRowIndex,2) = row.Column("SRU").CurrencyValue.ToString(Ital)

When I wrote simple… I had to realize I was wrong (with your help), then search / found how to do it.

And do not forget then need to set an offset to the Column (AligmentDecimal)… where I display the Currency or everything on the right of the decimal character disappears…

Is it clear now ?

I have another problem to resolve before disclosing the project.

[AlbertoD]

@Emile_Schwarz

And do not forget then need to set an offset to the Column (AligmentDecimal)… where I display the Currency or everything on the right of the decimal character disappears…

You may want to create a Feature Request, if the problem is that DesktopListbox is not aware of AligmentDecimal with locale that does not use a period but a comma. This is not tested by me so just my guess from what you describe.