Subject | RE: [firebird-support] UDF not working |
---|---|
Author | Alan McDonald |
Post date | 2007-02-13T11:18:33Z |
> (using D7e and FB1.0.3.972)I'd suggest looking again at your definition again. The error message is not
> Hi
>
> Can you direct me to the place to find information on UDFs and this
> version of FB? My problem is that some UDF's that worked with IB
> 6.0.2 don't work any more. My udf library is written in Delphi and is
> originally based on FreeUDF.
>
> For example f_LRtrim does not work. I know that the function is coded
> into the dll because I code and compile the dll myself. The external
> function is present in the database after having been declared. It's
> is there amongst all the others, and bear in mind that some of the
> other functions do work, even returning strings, so it is should not
> be a parameter passing issue. So what is the problem?
>
> this works: select f_Ltrim(lastname) from contacts
> this does not work: select f_LRtrim(lastname) from contacts
>
> this is the error message:
> Error at line1 - invalid request BLR at offset 63
> function F_LRTRIM is not defined
> module name or entrypoint could not be found
>
> Can you can help or send me to the place where I can read up about
> this please.
>
> Regards Q
suggesting that it's failing at the execution, but that it's not being found
at the definition point.
Alan
(read it again closely
DECLARE EXTERNAL FUNCTION F_LRTRIM
CSTRING(254)
RETURNS CSTRING(254) FREE_IT
ENTRY_POINT 'lrTrim' MODULE_NAME 'FreeUDFLib.dll'