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

     Any time more than one table is used in a query or view, it is best
to name fields with this format: "table name"."field name". Looking at
the SQL of a query containing fields from two or more tables, this is
the format used. However, when only one table is involved, the "field
name" format is sufficient.
     I would still like to see the SQL for your query. Could you send it
to me off list?
--Dan

On Thu, 2012-01-26 at 18:37 -0500, Jay Lozier wrote:
> 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