Page 1 of 1

[Solved] Not able to enter 6.14 as a Number of Decimal

PostPosted: Mon Aug 26, 2019 3:59 am
by dreamquartz
Hello Everyone,

I am using LO 6.2.5.2 and the Split HSQLDB 2.5.0.
I have a record ID as INTEGER and need to have it changed to either Numeric or Decimal ID, to that I can enter a Decimal Number like: 6.14.
What ever I tried, including creating a new table, the record is rounded downward, showing trailing '0'.
Is this a BUG?

Dream

Attached a little DB

Re: Not able to enter 6.14 as a Number of Decimal.

PostPosted: Mon Aug 26, 2019 4:47 am
by UnklDonald418
No bug here.
Right click on table tNumber and select Edit.
Notice that both Number and Decimal fields have 0 decimal places.

It's easy to fix in the Embedded database, but for a JDBC connection you will need something like
Code: Select all   Expand viewCollapse view
ALTER TABLE "tNumber" ALTER COLUMN "Decimal" DECIMAL(10,2)

followed of course by View>Refresh Tables

Re: Not able to enter 6.14 as a Number of Decimal.

PostPosted: Mon Aug 26, 2019 6:40 am
by dreamquartz
UnklDonald418 wrote:No bug here.
Right click on table tNumber and select Edit.
Notice that both Number and Decimal fields have 0 decimal places.

It's easy to fix in the Embedded database, but for a JDBC connection you will need something like
Code: Select all   Expand viewCollapse view
ALTER TABLE "tNumber" ALTER COLUMN "Decimal" DECIMAL(10,2)

followed of course by View>Refresh Tables

Yup that works.

I tried the same thing, and it did not work.
Scary......

Dream