Date: prev next · Thread: first prev next last
2023 Archives by date, by thread · List index

Hi, LOBase experts
I have been working on a LOBase database where the fields of interest are
(a) the husband (=table ”t_man”) and his ”surname” and ”firstname”
(b) the wife (= table ”t_wife”) and her ”firstname” (husband and wife have same surname).

I want the Report Builder to produce a list with the husbands surname is in one column and the both first names are concated in another (e.g. ”Bond”, ”Harry & Linda”). I have managed to in the query write a function that works OK as long as the husband has a wife, but In case there is only a Harry -- no wife Linda -- then the concate result is ”null”.

The question is how to build a concate function that covers both these Report outprints:
”Bond, Harry” and ”Bond, Harry & Linda”.

My PC is a Win11 Pro; LO-version; HSQLDB

Grateful for any help
Pertti Rönnberg

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.