Subject RE: [firebird-support] Re: carriage return, line feed
Author Thomas Steinmaurer
Hi J├╝rgen,

> --- In firebird-support@yahoogroups.com, "Dorin Pacurar" <dopa@z...>
> wrote:
> > On Sun, 18 Jul 2004 20:17:23 -0600, Hans Hoogstraat <hhoogstraat@s..
> .>
> > wrote:
> >
> > > Log = 'My Log Line' || ASCII_CHAR(13) || ASCHII_CHAR(10);
> >
> > Thanks Hans,
> > It worked.
> > Dorin
>
> Hi,
> this doesn't work on my machine.
> When I try to compile the proc I get the following
> error:
>
> Dynamic SQL Error.
> SQL error code = -804.
> Function unknown.
> ASCII_CHAR.
>
> Is the ASCII_CHAR function part of an UDF?

Yes. It's part of the ib_udf library.

If you don't want to use an UDF, then give the following
a try:


DECLARE VARIABLE MY_TEXT VARCHAR(1000);
...
MY_TEXT = 'Hello
';
MY_TEXT = MY_TEXT || ' world';


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com