Subject Re: UDF to provide Hexadecimal string
Author Steve Harp
--- In firebird-support@yahoogroups.com, "Ricardo Uzcategui"
<ricardouven@c...> wrote:
> it's easy. in delphi, you can make a udf with a function with this body:
>
> interface
>
> function IntToHex( var nNumber: integer ): pchar; cdecl; export;
>
>
>
> implementation
>
> function IntToHex( var nNumber: integer ): pchar;
> begin
> result := format('%1.2x',[nNumber])
> end;
>

I created a Delphi DLL using your suggestion and placed it in the
Firebird UDF folder. I then declared it in me schema as so.

declare external function IntToHex
integer
returns
cstring(254)
entry_point 'IntToHex' module_name 'XpressUDF.dll';

and get the following error.

ISC ERROR MESSAGE:
invalid request BLR at offset 116
function INTTOHEX is not defined
module name or entrypoint could not be found

Any suggestions?
Steve