Manuel NAUDIN wrote:
a simple query "PROD_QUERY" created in sql mode with direct sql on :
SELECT "id_prod", "prod_name" || ' ' || "prod_details" AS "product
description" FROM "PRODUCTS"
What is unexpected (to me at least) is that if the "prod_details"
field is empty, "product_description" is empty too, although there's a
string in the "prod_name" field.
Hi Manuel,
That is the way HSQLdb handles it, the only way really to change that I
suppose would be for HSQL to update their code. Which I think is in
their tracking system for the 1.9 release, but don't quote me on that. I
know I saw it in the mailing lists there a while back, but just now when
I went to reference it I couldn't find it.
Anyway - for today what you need to do is use the CONCAT Function. Not
as nice, but it does offer you the ability to then run the query in GUI
designer mode, which you also can not do with versions of Base up to and
including 2.3.1 ( I think I got that right ), OO.org 2.4 however will
recognize the || function in the designer.
SELECT
"id_prod",
CONCAT( "prod_name", CONCAT( ' ', "prod_details") )
AS "product description"
FROM "PRODUCTS"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
