| Subject | Re: [ib-support] Appending a CR/LF to a string |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2002-04-22T06:18:15Z |
On 19 Apr 2002 at 14:21, GreatDayDan wrote:
OpenSalesborders = OpenSalesOrders ||
Cast(:SalesOrderId as VarChar(7)) || '
';
New line between apostrophes is not a mistake or auto word wrap of
a mailer. It is what you need. Of course, to input this statement you
have to use a tool which allows multi-line statements and doesn't
modify them.
SY, Dimitry Sibiryakov.
> OpenSalesorders = OpenSalesorders ||Try this:
>Cast(:SalesOrderId as VarChar(7)) || #13#10;
>
> I would LIKE it to have a CR/LF after each order
>id. The line above does not work (compiler chokes on
>the #).
OpenSalesborders = OpenSalesOrders ||
Cast(:SalesOrderId as VarChar(7)) || '
';
New line between apostrophes is not a mistake or auto word wrap of
a mailer. It is what you need. Of course, to input this statement you
have to use a tool which allows multi-line statements and doesn't
modify them.
SY, Dimitry Sibiryakov.