Sascha_S
December 6, 2024, 10:37am
16
You like to refer to literature in documentation, forums and the like. However, when you need an answer yourself, you often like to take the easy way out…
https://sqlite.org/datatype3.html
What is the currently recommended way to store currency values in s SQLite database? I see the following in the Xojo docs:
[quote]
Use the REAL data type to store currency values in conjunction with DatabaseRecord.CurrencyColumn and DatabaseField.CurrencyValue.[/quote]
But I also see others in the forum saying to use INTEGER.
I will definitely need to compare currency values, along with adding and multiplying them. I imagine I can store them as cents in an INTEGER field, and then rely on the…
@Jason_Tait already recommended to use REAL , but you just dismissed it…
