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: [email protected] 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
