Hi everybody,
Hi Frank (here is a question for you)
This time I've done my search carefully: as the *issue 59211* says, it is
impossible to pass a standard SQL concatenation operator [ || ] through
OOoBase's PARSER.
Let's take the following situation: we want to display the data of two
or more strings columns in a list
box or combo box, so we must concatenate them.
For example, in a table we have the columns first_name, last_name,
user_id, and we want to display "Last_name, Fistname [user_id]".
We must select as data source for the list box an SQL statement that
concatenates the columns.
Different from other RDBMS, like MySQL, whose CONCAT() function
concatenates any amount of strings ( CONCAT(string1, string2, string3,
...) ), HSQLDB's function ONLY concatenates two strings. So in order to
get the result we want, we can:
* use nested HSQLDB CONCAT() functions
* the simplest way: use the standard SQL concatenation operator: ||.
For the example mentioned above :
SELECT last_name || ', ' || first_name || '[' || user_id || ']' AS
user_full_name FORM my_table
This works fine with NATIVE SQL, but OOo PARSER throws always an
exception ( *issue 59211* ).
This will have a definite solution with the *multicolumn* list and combo
boxes feature: as we can read in Frank's specification abstract
http://dba.openoffice.org/specifications/forms/multi_column_list_controls.odt
OpenOffice.org extends its existing list and combo box form
controls to allow for *more than one column*.
That is, content in those list-like controls can be displayed
in a tabular fashion. For controls *bound to database* tables
or queries, as usually to be found in database forms, the
existing data binding capabilities are extended to
accommodate to multiple columns.
My question for Frank: is there a release version for this new feature?
OOo 3.0? In OOo-dev 2.3 it's still missing.
I'm looking forward for it, and all users coming from MSWin will welcome
this for-so-long-wanted enhancement.
By
Ariel Constenla-Haile
La Plata
Argentinien.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
