Subject Alltrim UDF in FB 2.5
Author Alan J Davies
Hi, I'm trying out against existing databases.
Clean install on XP

This code in 2.5 gives error "Connection was lost to database:"
(Crashes - I can then restore connections with no problem.)
'*'||alltrim(partno_prefix)||alltrim(Partno)||alltrim(partno_suffix)||'*' from
It works perfectly in 2.1
Its used to generate barcodes, hence the * and the need to use alltrim.
Trim does not work because if there is no partno_prefix or partno_suffix
it gives a null result as the concatenation.

I recall seeing some information about certain Udfs now being native in
Firebird, but can't remember where or when, and I've checked my own

The Alltrim udf is part of fudlib.dll.
Can anyone point me in the right direction, please.

Alan J Davies