On 04/10/14 21:37, Peter Goggin wrote:
On 04/10/14 21:13, Dan Lewis wrote:
On 10/03/2014 11:24 PM, Peter Goggin wrote:
While working through the documentation I appear to have found a
problem.
The following query works:
SELECT "ID", "Title", "Pub_Year" FROM "Media"
It returns 8 rows.
The following query fails
SELECT "ID", "Title", "Pub_Year" FROM "Media" LIMIT 5
The error complains about 5 being an unexpected token.
I created the query in both design and sql view and get the same
result. I repeated with several tables and got the same result and
problem.
I found that if I used sort on a field then no matter where I
created the query (design or sql mode it worked)
The documentation implies that this is a problem from earlier
versions of the data base, prior to 4.1. and also the limit could
only be set in direct SQL mode. I can set the limit in both modes
but as stated an order field condition is rquired.My version is the
one from the ubuntu repository and claims to be version
libreoffice-base 1:4.2.6.3-0ubuntu1. I presume this means it is
4.2.6.3 and therefore should not have the LIMIT limitation.
If I need to load a later version of the data base where do I get it
from?
If this problem is a bug where do I report it?
Regards
Peter Goggin
I ran the same query without any problem using 4.2.6.3 that I
downloaded from the LibreOffice web site. I also use Ubuntu as my OS
(12.04) so yours should have worked.
A couple of possible problems though:
1) Did you download Media_with_Macros.odb or Media_without_Media.odb
and run create the query in one of these, or did you use the database
you created? (If the latter, there might be a problem with your
database.)
2) The LibreOffice distributed by Ubuntu has been modified from the
version distributed on the LibreOffice web site. This error could be
caused
by a bug introduced by the modification process. This has been
known to happen down through the years and has happened in a variety
of distributions of Linux.
For #1, you should download the English version of the database
file mentioned in the Query chapter. (It probably does not matter
which one.) Create and run the query. If you still get the error, the
problem is with the Ubuntu version of LibreOffice.
For #2, I always remove the Ubuntu version of LibreOfficeusing
Synaptic first when I install a newer version of Ubuntu. Then I
download and install the versions including the help packs that I
want from the LibreOffice web site. The menu will only show the
Ubuntu version unless you do it in this order. Once the Ubuntu
version is deleted, all version installed from the LibreOffice web
site appear in the menu.
Right now I have LibreOffice 4.2.6.3 and 4.3.2.2 installed, and
I use both versions for a variety of purposes including testing them
for how Base works in both of them. Specifically, I can check the
problem you have had with both versions or even 4.2.7.1.
Dan
I down loaded the sample data base Media_with_Macros.odb or
Media_without_Media.odb. I was using the without version. As I am
checking the documentation I am using the sample data bases rather
than my own since the samples in the documentation come from the ample
databases. It appears the ubuntu version of LibreBae is the cause of
the problem.
I am not quite sure how I do what is required to get the proper
version of the LibreBase software. (By the way as you know in ubuntu
it does not come bundled with LibeOffice but requires a separate
download.
Many users of librebase on ubuntu will use the version in the ubuntu
repository. While I can obviously ( with some guidance) download the
latest versions form the LibreOffice site, should I be checking the
documentation against the ubuntu version or the official site version?
Or do I need to check it against both?
There are a number of linux distributions which bundle LibreOffice in
the installation. Do all of these have the same sort of problems as
Ubuntu?
Regards
Peter Goggin
I retried the queries using the withmacros version of the sample data
bases. This refused to load cleanly until i enabled macros. Now the
queries work correctly in both databases.
Regard
Peter Goggin
--
To unsubscribe e-mail to: documentation+unsubscr...@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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted