-------- Originele bericht -------- Onderwerp: [users] ooBase: Concatenating strings in a query Van: Mario R. Osorio <[email protected]> Aan: [email protected] Datum: Sun, 8 Aug 2010 16:16:40 -0400 > (ubuntu 10.04 & oo 3.2) > > Hiello everyone, > > I'm trying to concatenate 2 strings in a query, BUT i need to show them as a > multiline string. I have tried to add chr(10), or chr(13) or chr(10) + > chr(13) or chr(13) + chr(10); but I still cannot get what I need. > > What do I need to do? > > TIA! > > DTB > === > Mario R. Osorio > "... Begin with the end in mind ..." > http://www.google.com/profiles/nimbiotics > > Use the '||' operator for concatenation and not the '+'. If the cr/nl is displayed depends on the format of the field on your form. You can change the properties of you column in the result window in th SQL editor (right click on the header of the column), but I believe that in the table-view and the SQL editor, you can not set the 'multi-line' property. You can do it on a form.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
