lobolo2000 wrote:

> Just a quick update. I was able to solve the UDF error: Invalid request
> BLR at offset 29.
> It turned out that I had used the wrong case (lower instead of upper) in
> the DECLARE EXTERNAL FUNCTION entry point!!
> But this still does not solve the ASCII_CHAR prob (unless I use other UDF
> libraries). I will continue my efforts in making the CRLF function myself.
> It'll be a good practice.
>

Another reason to use the Firebird version :-)

try
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

instead of

DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CHAR(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';


2000-11-28 07:47 fsg

* interbase/extlib/ib_udf.sql:

Changed declaration of ascii_char in ib_udf.sql to get correct
result as proposed by Claudio Valderrama


Frank

--
"Fascinating creatures, phoenixes. They can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
http://firebirdsql.org