[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from atjen...@openoffice.org Mon May 25 01:26:51 + 2009 --- Checked w/ test document under OO.o 3.1, Windows and northwind.mdb Closing - 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
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Tue Aug 19 11:34:03 + 2008 --- Please verify. Thanks. - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.1 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 10:19:22 + 2008 --- As work around you may use simply + like select companyname, address, (postalcode + city) as fullcity from customers Fixed in cws dba31b - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User fs changed the following: What|Old value |New value Target milestone|OOo 3.0.1 |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 20:11:21 + 2008 --- > Also, SRB 1.0.5 was used to confirm this. There is no such thing as SRB 1.0.5, only some premature releases of third-party builders of OOo :) (What I want to say: As long as 1.0.4 is the latest official release, "1.0.5" is ambiguous, as there might in fact exist multiple packages with this number.) For the issue: given that using "&" as concatenation operator is not standard SQL, I don't think this is 3.0.1 worth. - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Assigned to|dbaneedsconfirm |oj Target milestone|--- |OOo 3.0.1 --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 16:46:28 + 2008 --- Also, SRB 1.0.5 was used to confirm this. Assigning to developer, setting initial target - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 User atjensen changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 16:44:58 + 2008 --- Confirmed w/ DEV300 m_29, XP - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92409 --- Additional comments from [EMAIL PROTECTED] Sun Aug 3 10:21:40 + 2008 --- Created an attachment (id=55513) Testdoc to reproduce the error - 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]
[dba-issues] [Issue 92409] RPT: SRB fails with string concatenation queries
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 +
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]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
