Hi Peter, > 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 have tested it with the same database and LO 4.2.7.1. The query works as expected. Could create it in the GUI and directly in SQL without any problems. > > 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) There is no difference between switching from GUI to SQL-input. The code will be interpreted by Base, when ther isn't pressed the button "SQL" to direct processing the SQL-code. > > 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. Really in direct SQL-Mode? You have to switch Design View off and then press the button SQL (or go to Edit → Run SQL command directly.). The direct mode works in every LO-version, because it is executed by the same HSQLDB-database. > 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? You don't need any other version of the database, because the HSQLDB in the background is the same for all LO-versions. Don't know if this is a special problem with packages from Ubuntu. Regards Robert -- To unsubscribe e-mail to: [email protected] 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
