[libreoffice-users] Re: Calculated fields not showing decimal places in BASE query

Le 07/09/11 18:34, John Mullen a écrit :

Hi John,

> SELECT  1.00, "CONTRACTS.Rental" FROM "CONTRACTS"
>
> this returns  1.00    150
>
> Any idea why?

IMHO, this could be either a bug in the LibO SQL parser, or maybe the
TYPE converter (jni_uno2java.cxx type converter that handles conversion
of data types between Uno and java types).

Best thing to do would probably be to open a bug report.

If you save that query, and then run it with SQL preprocessing switched
off in the query designer, does it work as expected, i.e. give you 1.00
and 150.00 ?


Alex


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted