On 28 Aug 2014 01:10:40 -0700, "[email protected] [firebird-support]" <[email protected]> wrote: > Perhaps my problem is in an incorrect installation setting? > > I have FB 2.5.3 on a laptop. Win 7 32 bit. > I introduced a stored procedure and in it call F_LEFT(:varName, 24) to > truncate :varName from a vc(48). > This DB is used in Win 7 and win 8.1 else where without problem. > > When I run the procedure on this one box I get > > ISC error 335544343 > invalidrequest BLR @offset2452 > function F_LEFT is not defined > module name or entry point could not be found > Error while parsing procedure myProc's BLR > > I reinstalled Firebird. > I did a backup and restore of the DB. > No improvement. > > Any advice for me, beside "work smarter"?
Firebird itself doesn't have a function or UDF named F_LEFT, it does have the builtin function LEFT (see http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-left.html ). Most likely those other databases or servers have a UDF installed (and declared in the database) to provide F_LEFT. As far as I know F_LEFT is provided by FreeAdhocUDF: http://freeadhocudf.org/index_eng.html You need to install it in your database server **and** define the function entry point in the database. However given the fact that similar functionality is provided by Firebird (since 2.1), I'd suggest to migrate to the built-in LEFT. Mark
