To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92409
Issue #|92409
Summary|RPT: SRB fails with string concatenation queries
Component|Database access
Version|DEV300m29
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|SRB
Assigned to|dbaneedsconfirm
Reported by|newuser4
------- Additional comments from [EMAIL PROTECTED] Sun Aug 3 10:20:43 +0000
2008 -------
OOo-Dev3.0 (DEV300_m29)
SRB 1.0.4
Windows XP Sp2
Using an ODBC data source (Microsoft Access Driver 4.00.6304) SRB throws an
error if the query statement contains a string concatenation expression like:
SELECT fieldname & fieldname AS alias
OR
SELECT {fn concat (fieldname,fieldname)} AS alias
The error message returned is the following:
SQL Status: S1000
An error occured while creating the report.
An exception of type com.sun.star.lang.WrappedTargetException was caught
caught a com.sun.star.report.ReportExecutionException
The attached file contains two reports which both fail. Reports silently fail
when run from the report panel while they throw the before mentioned error when
executed throught the report designer interface. Both queries work as expected
when testing them in the Sun Report Builder query designer.
The attached file requires that a DSN named "northwind" already exists on the
test system and it must point to the standard database example Northwind
available here:
http://www.microsoft.com/downloadS/details.aspx?familyid=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=en
---------------------------------------------------------------------
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]
