Subject Re: [firebird-support] Selecting records based on a list of ids ...
Author Aage Johansen
On Tue, 6 Apr 2004 20:52:48 +0000 (UTC), Rafael Szuminski wrote:

> ...
> Of course no solution is perfect. With this one I have run into issues
> regarding the 80 characters limit on the substr and substrlen functions.
> I tried increasing this in the function declaration, but no matter what I
> increase it to I always get an overflow error when I pass more then 80
> char to it. Has anybody experienced the same issue with substr and
> substrlen?


I believe that there was a thread on this a while back. Maybe the (80) had
been just a marker, but now (in Fb/1.5) the 80 was taken literally (in the
UDF) - I don't really recall...

When you changed the UDF: did you restart the server before testing


--
Aage J.