To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=90066
User atjensen changed the following:
What |Old value |New value
================================================================================
CC|'' |'atjensen'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed May 28 16:03:40 +0000
2008 -------
The functions in the query designer are dependent on the syntax supported by the
database engine used. In the case of HSQLdb, the engine used for embedded
databases, the CONCAT function does only support 2 parameters.
However, if running against a database that supports more then this, that that
is accepted. For instance running against MySQL CONCAT( COL1, STRLITERAL,
COL2,...) is quite valid and the Base query designer accepts it without
complaint.
I will close this issue then as worksforme.
The HSQLdb project team can be contacted at http://hsqldb.org and it would be
the appropriate place to enter a request for enhancement to expand the engines
implementation of the CONCAT function.
---------------------------------------------------------------------
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]
