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+h...@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
