Hello, I've found an unexpected behavior when building a query with concatenation and memo field. (using OOo 2.3.0 under Mac OS X.4.10 / X11)
A simple table "PRODUCTS" with id_prod INTEGER IDENTITY PRIMARY KEY prod_name VARCHAR 50 prod_details LONGVARCHAR (memo field) 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. Sample base available here : http://www.cijoint.fr/cij25969289429926.odb Any hints or advice appreciated Thanks, Manuel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
