Good Morning!

Thanks, Hellen. I'll give this a try.

Thanks...Dan'l



--- Helen Borrie <helebor@...> wrote:

> At 02:21 PM 19-04-02 -0700, you wrote:
> >Good Morning!
> >
> > I am trying to build a list of open sales
> orders
> >like this:
> >
> > OpenSalesorders = OpenSalesorders ||
> >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 #).
>
> Yup - those are Delphi constants. :-))
>
>
> > The desierd result is something like this:
> > 51239
> > 51347
> > 43945
> >
> > Can anyone tell me how to do this?
>
> Use the UDF from the FreeUDFLib, a fixed version of
> which you can get from
> www.cvalde.com. The func you want is Character(),
> which takes an ascii
> code as input and returns the actual character.
> Apart from storing the
> actual characters as columns in a table (copy-pasted
> from a textfile) I
> don't know of any other way you can get "untypable"
> characters into an
> input clause.
>
> Once you have the lib installed and the func
> declared to your db, you will
> be able to store the linebreaks this way:
>
> OpenSalesorders = OpenSalesorders ||
> Cast(:SalesOrderId as VarChar(7)) ||
> Character(13)||Character(10);
>
> --- H
>
> All for Open and Open for All
> Firebird Open SQL Database � http://firebirdsql.org
> �
> http://users.tpg.com.au/helebor/
>

_______________________________________________________

>
>

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/