To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55169
Issue #:|55169
Summary:|syntax error in generated SQL statement
Component:|Database access
Version:|OOO 2.0 Beta2
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P2
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|wolfgangbackes
------- Additional comments from [EMAIL PROTECTED] Wed Sep 28 02:23:31 -0700
2005 -------
When I generate a view with a cascade of two left outer joins, the system pops
up the following error message:
Unexpected token Kunden, requires SELECT in statement
[SELECT "Kunden"."Kundennummer", "Titel","Titel", "Personen"."Vorname", "Person
en.Nachname" FROM ( "Kunden" "Kunden" LEFT OUTER JOIN "Personen" "Personen"
ON "Kunden"."Person" = "Personen"."ID" ) LEFT OUTER JOIN "Titel" "Titel"
ON "Personen"."Titel" = "Titel"."ID" ]
The SQL-Window shows the following statement:
SELECT "Kunden"."Kundennummer", "Titel"."Titel", "Personen"."Vorname", "Persone
n"."Nachname" FROM { OJ ( "Kunden" "Kunden" LEFT OUTER
JOIN "Personen" "Personen" ON "Kunden"."Person" = "Personen"."ID" ) LEFT OUTER
JOIN "Titel" "Titel" ON "Personen"."Titel" = "Titel"."ID" }
There are three tables: Kunden, Personen, Titel
The field Kunden.Person references the field Personen.ID which is the primary
key of table Personen. The field Personen.Titel references the field Titel.ID
which is the primary key of table Titel.
The view is to deliver a list of clients (Kunden), identified by its number
together with name and (if any) title.
If I delete the curly braces, changing the SQL-statement (manually) to:
SELECT "Kunden"."Kundennummer", "Personen"."Vorname", "Personen"."Nachname", "T
itel"."Titel" FROM "Kunden" LEFT OUTER JOIN "Personen" "Personen"
ON "Kunden"."Person" = "Personen"."ID" LEFT OUTER JOIN "Titel" "Titel"
ON "Personen"."Titel" = "Titel"."ID"
the list appears as desired. However, when I reenter the design mode (whitout
changing the view), my changes of the SELECT-statement are overwritten with
the original version. Pressing the preview button raises the same error
message again: Unexpected token ...
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
