At 06:27 AM 25/10/2006, you wrote:

>Hi, i'm new in this group, and i need some help.
>It's there any issue with the STRFORMAT in FB 2.0 and the UDF_FILE.DLL?

There is no "UDF_FILE.DLL" that I know of. The two shipped UDF
libraries are ib_udf.dll and fbudf.dll, neither of which has a
function STRFORMAT.

>Any time i try to use it got this ERROR: function STRFORMAT could not
>be matched. The other functions in the dll are doing ok.

Could it be that your function is in some custom library that you
haven't moved into the \UDF subfolder of your Fb 2.0 installation?

The isql utility SHOW FUNCTION statement can help you to find out the
details of a UDF that is declared in your database. For example, I
have a specialised declaration of a function that lives in fbudf,
which I have declared as longstring2blob:

SQL> show function longstring2blob;

Function LONGSTRING2BLOB:
Function library is fbudf
Entry point is string2blob
Argument 1: BY DESCRIPTOR VARCHAR(32765) CHARACTER SET NONE
Returns BLOB
SQL>

HTH
./heLen