Subject RE: [firebird-support] FB engine not finding F_LEFT
Author Mark Rotteveel
On Thu, 28 Aug 2014 10:32:51 +0200, "Svein Erling Tysvær
svein.erling.tysvaer@... [firebird-support]"
<> 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
> but I could be wrong.
> Generally, I think I would recommend you to use SUBSTRING(:varName FROM
> FOR 24) rather than F_LEFT.

Or simply use the built-in function LEFT: