[Solved] Of decimal or numeric field in form to Currency

Creating and using forms

[Solved] Of decimal or numeric field in form to Currency

Postby gkick » Tue Dec 03, 2019 5:48 am

Observing a strange behaviour in my assets db

Was trying to enter a purchase value of 1.200.000 and it changed back to 1.000.000
The forms control property indeed show min max value of 1.000.000
The numeric or decimal data type(s) work fine in forms, however if converted to currency there is a problem. Anyone aware of this behaviour (bug?) I mean one wouldn t often have a million dollar item in an asset db, but hey in most of South America you are a millionaire with the equivalent of 2000 AUD
Last edited by gkick on Tue Dec 03, 2019 8:49 pm, edited 1 time in total.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 133
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Change of decimal or numeric field in form to Currency

Postby Villeroy » Tue Dec 03, 2019 2:52 pm

What is the column type in the underlying table?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27373
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Change of decimal or numeric field in form to Currency

Postby gkick » Tue Dec 03, 2019 4:16 pm

Hi Villeroy,

original datatype decimal.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 133
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Change of decimal or numeric field in form to Currency

Postby F3K Total » Tue Dec 03, 2019 4:57 pm

Seems to be a problem with a Currency-field as column within a table control.
Use a formatted field.
gkick wrote:The forms control property indeed show min max value of 1.000.000
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 939
Joined: Fri Dec 16, 2011 8:20 pm

Re: Change of decimal or numeric field in form to Currency

Postby Villeroy » Tue Dec 03, 2019 5:05 pm

DECIMAL with a length of 8 and 2 decimals means that you can't store numbers bigger than 999,999.99
Make field types as big as necessary and as small as possible.
Adjust the min/max values of your form controls according to the underlying field types.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27373
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Change of decimal or numeric field in form to Currency

Postby gkick » Tue Dec 03, 2019 8:46 pm

Thanks all ! So its the systems default length of the datatype unless specified otherwise.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 133
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests