On Fri, 2017-09-15 at 19:19 +0200, Robert Großkopf wrote:
Hi Harvey,Hi Robert, Thanks for answering. Your suggestion, however, do not work on my Opensuse Leap 42.3 / LibreOffice 5.3.3.2 configuration. > I use the Query design feature to enter "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" or "Nachname" || IFNULL( ', ' || "Vorname", ' ') Both above return 0 (yes, zero!) for every record. Only the "Partnervorname" field has NULL values. I didn't expect concatenation to be treated like 'multiplication', but I learn something new every day! Neverthless, something is not right here. However, COALESCE ( CONCAT( "Vorname", SUBSTR( ' & ', 1 ), "Partnervorname", SPACE( 1 ), "Nachname" ), CONCAT( "Vorname", SPACE( 1 ), "Nachname" ) ) delivers the required result.Which database do you use? Internal HSQLDB? My system here: OpenSUSE 42.2, LO 5.4.1.2. Have tested all this code for the Base-Handbook, so I am interested why it shouldn't work for you. Must say I didn#t test how it would work when entering the code in GUI mode, not switching to SQL mode. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3
I have a backend Mariadb 10 which I access directly using the using the MySQL connector. Cheers Harvey
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted