the function strlen is absolutely not my problem.
I removed it meanwhile. I only used it to prove that by exceeding a
length of 255 characters in the resultstring of a concatenation the
error '..is not a valid floating point value' occurs.
But obviously nobody ever had the problem..
regards, christoph

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
>
>
> > Hi christoph, this is bug, but this bug is Yours,
> >
> > let we see the definition of STRLEN function
> >
> > DECLARE EXTERNAL FUNCTION substrlen
> > CSTRING(255), SMALLINT, SMALLINT
> > RETURNS CSTRING(255) FREE_IT
> > ENTRY_POINT 'IB_UDF_substrlen' MODULE_NAME 'ib_udf';
> >
> > So if You exceed 255 chars, the function fails, it's OK.
> >
> > You can write Your own strlen with longer strings.
>
> Declaring it with CSTRING(somethinglonger) should work.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,

Oracle &

> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>