To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73215
Issue #|73215
Summary|Query incorrectly reconstituted
Component|Database access
Version|OOo 2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|matagl
------- Additional comments from [EMAIL PROTECTED] Sat Jan 6 14:46:29 -0800
2007 -------
This seems like it should have already been detected but I couldn't find it in
the issues database.
I create a query manually by entering the code directly. It saves and runs
fine. Right-click edit to work with it some more and it comes up in design
mode. The table-based query description at the bottom seems fine but when Base
reconsitites the query, it has a syntax error. syntax error, unexpected $end,
expecting BETWEEN or IN or SQL_TOKEN_LIKE
The query where I hit this is:
select "Inv", "Date", "Amount"
from "Entry" as "Entry0"
where "Date" = (select max("Date") from "Entry" as "Entry1" where "Entry1"."Inv"
= "Entry0"."Inv")
and "Type" = 'V'
order by "Inv"
Let me know if you need a schema to go with it, but it's pretty straightforward.
---------------------------------------------------------------------
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]
