To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113251
------- Additional comments from osav...@openoffice.org Wed Jul 21 12:34:27
+0000 2010 -------
Hmmm, ok the queries appear to run okay in Forms so I must have been confused at
that point.
However, running a Report displays, for example:
The query with the statement
'SELECT DISTINCT "c1"."contact" AS "Name", CONVERT(char(11),"ch"."ondate",109)
AS "Pack 1 Sent",
(SELECT DISTINCT CONVERT(char(11),"ch"."ondate",109)
FROM "contact1" AS "c2"
INNER JOIN "CONTHIST" AS "ch" ON ("ch"."accountno" = "c1"."accountno" AND
"ch"."ref" LIKE 'Depression Article & Special Offer on Omega-3 EPA Vegepa
Capsules%') AND "ch"."ref" <> ''
WHERE "c1"."source" LIKE '%depression%' AND ("c2"."contact" = "c1"."contact"))
AS "Pack 2 Sent",
(SELECT DISTINCT CONVERT(char(11),"ch"."ondate",109)
FROM "contact1" AS "c2"
INNER JOIN "CONTHIST" AS "ch" ON ("ch"."accountno" = "c1"."accountno" AND
"ch"."ref" LIKE 'Inspirational story from manic depressive Helen McNallen%') AND
"ch"."ref" <> ''
WHERE "c1"."source" LIKE '%depression%' AND ("c2"."contact" = "c1"."contact"))
AS "Pack 3 Sent",
(SELECT DISTINCT CONVERT(char(11),"ch"."ondate",109)
FROM "contact1" AS "c2"
INNER JOIN "CONTHIST" AS "ch" ON ("ch"."accountno" = "c1"."accountno" AND
"ch"."ref" LIKE 'Depression Help Pack - The Importance of Exercise%') AND
"ch"."ref" <> ''
WHERE "c1"."source" LIKE '%depression%' AND ("c2"."contact" = "c1"."contact"))
AS "Pack 4 Sent",
(SELECT MAX("cs"."TITLE") FROM "CONTSUPP" AS "cs" WHERE "accountno" =
"c1"."accountno") AS "Last Order Date"
FROM "contact1" AS "c1"
INNER JOIN "CONTHIST" AS "ch" ON ("ch"."accountno" = "c1"."accountno" AND
"ch"."ref" LIKE 'Depression Help Pack - thank you for downloading%') AND
"ch"."ref" <> ''
WHERE "c1"."source" LIKE '%depression%'
GROUP BY "ch"."ref", "ch"."ONDATE", "c1"."ACCOUNTNO", "c1"."CONTACT",
"c1"."SOURCE"
ORDER BY "c1"."contact" ASC'
could not be run.
Check your data source.
However, these same queries run from the Queries and Forms sections.
---------------------------------------------------------------------
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
