To reproduce the bug:
1) Create a new query in design mode and add a table
2) add either all or some fields to the query by double clicking on the
list of fields that has appeared
3) set a limit to how many records should be displayed, either by
entering a value manually in the box at the top that says "All" or by
selecting a suggested value from the dropdown menu beside said box
4) run the query by pressing f5
normally it should display the records from the selected table equal to
the value that I set previously, but instead I get an "unexpected token"
error.
On 15/09/16 06:13, Christopher M. Penalver wrote:
> Matteo Paolini, thank you for reporting this and helping make Ubuntu
> better.
>
> 1) Could you please provide an example Base file?
> 2) Could you please provide a keyboard click-for-click of how to reproduce?
> 3) Could you please provide a screenshot of the error?
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>
** Attachment added: "odb29-Count and Group.odb"
https://bugs.launchpad.net/bugs/1623254/+attachment/4741512/+files/odb29-Count%20and%20Group.odb
** Attachment added: "Screenshot from 2016-09-15 11-29-38.png"
https://bugs.launchpad.net/bugs/1623254/+attachment/4741513/+files/Screenshot%20from%202016-09-15%2011-29-38.png
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1623254
Title:
Base: trying to set limits in queries gives an 'unexpected token'
error
Status in libreoffice package in Ubuntu:
Incomplete
Bug description:
When I'm trying to set a limit in a query about how many records it
should display I get an 'unexpected token' error, whether I input the
value manually or choose it from the dropdown menu.
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: libreoffice-core 1:5.1.4-0ubuntu1
ProcVersionSignature: Ubuntu 4.4.0-36.55-generic 4.4.16
Uname: Linux 4.4.0-36-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
CurrentDesktop: Unity
Date: Tue Sep 13 17:40:45 2016
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2016-06-14 (91 days ago)
InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Release amd64
(20160420.1)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1623254/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp