Ask Your Question
0

SQL Query Wizard in Base creates nothing but errors [closed]

asked 2013-04-01 23:23:23 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to use a fairly simple albeit large-ish (9,600 - 14,000 rows, 2 dozen columns, total object size ~3MB) spreadsheet in Base. Anything I plug into the query wizard, literally anything, any fields, any sort or search or condition reports back SQL query syntax error for every single field selected. Doesn't say what's wrong only that every single thing is wrong. The contents of every row are generally text or numerics, one column is a logical test for true-false with 99% of the results in that column being false. Whether I use one column or all of them or anything in between I get the same universal and complete comprehensive failure. Note this is an attempt to connect TO a spreadsheet - and NOT to use a Base file as the input into a spreadsheet. These are spreadsheets in either XLS format or ODS format. Either case there's only one tab in the spreadsheet.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 18:57:18.442197

Comments

I am having similar issues, however in my case it seems to be where numerical fields are involved in the query. As far as I can tell the SQL seems valid. Eg: SELECT "Membership"."Membership No" AS "Membership No", "Membership"."Last Name" AS "Last Name" FROM "Membership" "Membership" WHERE (Membership No = 4) Maybe there is a bug in the SQL engine?

wmarriage gravatar imagewmarriage ( 2013-07-23 10:06:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-04-05 15:00:22 +0100

Alex Thurgood gravatar image

Which version of LO was this with ? Has the problem gone away with a more recent (e.g. the latest) version of LO ? The SQL parser has had known issues in previous releases.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-04-01 23:23:23 +0100

Seen: 311 times

Last updated: Apr 05 '14