Re: [libreoffice-users] Base question - report exception on faultless query

On 01/26/2012 04:03 PM, Dan Lewis wrote:
> On Thu, 2012-01-26 at 20:30 +0000, Mark Stanton wrote:
> > I'm trying to produce a report based on a query, "trying to" being
> > the operative phrase.
> >
> > I have a query, it works just fine.
> >
> > I use the report wizard to produce a report based on the query (I
> > haven't worked out how to do that manually yet).  It presents me with
> > the correct fields.  I've arranged them the way I want them, at least
> > in a very basic form 'cos I'm still testing.
> >
> > Running the report gives me four errors, "SQL status S1000 An error
> > occurred while creating the report", "An exception of type
> > com.sun.star.lang.WrappedTargetException was caught." (Alright, that
> > was "info", not strictly speaking an error I s'pose), and two errors
> > that both say "Syntax error in SQL expression".
Check this link: https://issues.apache.org/ooo/show_bug.cgi?id=110535. 
Skimming the bug report the problem appeared to be not fully qualifying 
the field names in a JOIN. the field id exists in both tables and must 
be qualified by table1.id and table2.id. Why it would not throw an error 
earlier I do not know.
> > What SQL expression would that be then?  Since my query runs
> > correctly?
> >
> > Mark Stanton
> > One small step for mankind...
>       Some details would be nice. For example, what is the SQL for your
> query? (You will find it if you right click the query and select Edi in
> SQL. What were your selections in the Report Wizard? There should be
> some clues in the answers to these questions.
>
> --Dan


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@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