Пересылка: Concatenation (Building a string)

["Shulzhenko Vasyl" <vasilis@softline.kiev.ua>]

-----Исходное сообщение-----
От: Sujit.Pal@BankAmerica.com <Sujit.Pal@BankAmerica.com>
Группы: comp.databases.informix
Дата: 5 марта 1999 г. 0:46
Тема: Re: Concatenation (Building a string)


>
>
>
>Nick
>
>When you say "Does not work" do you mean that you cant see strDetail and
>strDiary in  strDetail (in your example #2)? In that case your strDetail is
>probably not large enough to hold both strings. Informix does not strip off
>trailing blanks by default, so you would need to do:
>
>LET strDetail = TRIM(strDetail) || TRIM(strDiary);
>
>HTH
>
>Sujit
>
>
>
>
>
>nanson@paulweiss.com on 03/04/99 01:01:09 PM
>
>To:   informix-list@iiug.org
>cc:    (bcc: Sujit Pal)
>Subject:  Concatenation (Building a string)
>
>
>
>
>I'm trying to build a string inside a stored procedure in a FOR EACH loop.
>Can someone explain the behavior of the following:
>
>strDetail = strDiary                This works
>
>strDetail = strDetail || strDiary              This doesn't work?
>
>strDetail = "MyText" || strDiary             This works
>
>strDetail = strDiary || "MyText"             This doesn't work?
>
>
>Sorry... VB programmer, not an Informix guy.
>
>Nick
>
>
>
>
>__________________________________________________
>
>This message is intended only for the use of the Addressee and may
>contain information that is PRIVILEGED and CONFIDENTIAL.
>
>If you are not the intended recipient, you are hereby notified that any
>dissemination of this communication is strictly prohibited. If you have
>received this communication in error, please erase all copies of the
>message and its attachments and notify us immediately.
>
>Thank You.
>___________________________________________________
>
>
>
>
>
>