Re: LibreOffice Base replacement
On Wed, 20 Nov 2013 09:03:32 +0000
Joe <joe@jretrading.com> wrote:
>
> I spent some time trying to print
> addresses. Postal addresses have varying fields present, and I don't
> want blank lines in the middle of my printed addresses. My Access
> solution involves a large ugly mess of IF statements, but it's simple
> and it works beautifully, and I had no success in trying to implement
> something similar in LO...
>
...which is often a sign of looking in the wrong place. OT, but in case
anyone stumbles across this thread while looking for the same thing:
The right place is in the MySQL documentation for concat_ws(), which
does pretty much exactly what I want, and even handles NULL fields
without masses of ugly code. Not portable across databases, but I'll
deal with that if/when I have to.
--
Joe
Reply to: