To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88394
User oj changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WONTFIX
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon May 5 10:23:56 +0000
2008 -------
The statement in the query contains an error which we accepted in 2.3.1. You
have to change it like
SELECT "Data"."ID", "Data"."CustomerID", "Data"."Town", "Data"."Telephone",
"Map"."Description", "Data"."MoreData" FROM "Map" AS "Map", "Data" AS "Data"
WHERE "Map"."CustomerID" = "Data"."ID" AND POSITION( 'i' IN "Town" ) <> 0
The function POSITION returns an integer and is compared in the example with a
String. When you change that one into an Integer all went well.
Best regards,
Ocke
---------------------------------------------------------------------
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]
