|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread|
|Messages 1 to 5 of 5 total|
|Simple Query - decimals appear where they should not - DBISAM 3.24|
|Sun, Oct 20 2019 2:11 PM||Permanent Link|
I have a simple table with 855 records and run the following query:
select sum(brutobedrag) as bruto, sum(nettobedrag) as netto from adm_bank
The result should be:
but the result is as follows:
Has anyone got an idea?
Attachments: error in sum.xlsx
|Sun, Oct 20 2019 4:32 PM||Permanent Link|
Not knowing any details, if the columns are of a floating point type, it's probably just the expected representation errors.
|Mon, Oct 21 2019 3:12 AM||Permanent Link|
As Fernando says probably a float. I'm guessing that its currency so I'd suggest changing the datatype to DECIMAL(19,2)
|Mon, Oct 21 2019 10:37 AM||Permanent Link|
Woops - just noticed I'm in the DBISAM group - so try currency
|Mon, Oct 21 2019 2:08 PM||Permanent Link|
I believe you meant BCD that in DBISAM is the same as DECIMAL in SQL or Currency Delphi type.