Correction:
I met to say I then installed FreeAdhocUDF not FreeUDFLib library. And according to their website I also install the 4 icu*44FAU.dll files to the Bin folder. http://freeadhocudf.org/documentation_english/dok_eng_icu.html I’ve rebooted the computer too, so I’m at a loss Anyone that installed these functions please help if you have any ideas, Mike From: [email protected] [mailto:[email protected]] Sent: Friday, August 07, 2015 1:37 PM To: [email protected] Subject: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined Importance: High Greetings All, On a new Windows 7 64 bit computer I installed Firebird v2.5.4 64 bit I then installed the FreeUDFLib 64bit functions I then did a firebird v1.5.3 backup of the metadata only and then restored this on firebird v2.5.4. I made sure to use the following switches during the restore -FIX_FSS_D(ATA) <charset> -- fix malformed UNICODE_FSS data -FIX_FSS_M(ETADATA) <charset> -- fix malformed UNICODE_FSS metadata Everything appears to be fine as the restore was successful. I decide to try to compile a stored procedure that used F_STRINGLENGTH and got the following error: invalid request BLR at offset 130 function F_STRINGLENGTH is not defined module name or entrypoint could not be found Error while parsing procedure DATETIME_TO_STR's BLR I verified that the function is defined with the following: select * from rdb$functions where upper(rdb$function_name) = 'F_STRINGLENGTH' It return one record with the following values: RDB$FUNCTION_NAME: F_STRINGLENGTH RDB$FUNCTION_TYPE: 0 RDB$QUERY_NAME: <Empty String> RDB$DESCRIPTION: <null> RDB$MODULE_NAME: FreeUDFLib RDB$ENTRYPOINT: StringLength RDB$RETURN_ARGUMENT: 0 RDB$SYSTEM_FLAG: 0 What could the issue be? Thanks, Mike [Non-text portions of this message have been removed]
