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
> [email protected]
>
>
--
For unsubscribe instructions 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/users/
All messages sent to this list will be publicly archived and cannot be deleted
