On Thu, 28 Aug 2014 10:32:51 +0200, "Svein Erling Tysvær [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 &quo t;work smarter"? > > I think this is saying that you have not installed the UDF function > F_LEFT. I don't think there is any function with that name natively in > Firebird (you can find it in FreeUDFLib, but then you need to install it), > but I could be wrong. > > Generally, I think I would recommend you to use SUBSTRING(:varName FROM 1 > FOR 24) rather than F_LEFT.
Or simply use the built-in function LEFT: http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-left.html
