--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Hi All,
> >
> > I am facing problem while executing SQL which has UDF
> > as a column.
> > in Firebird 1.5.2 service version(not the embedded one).
> >
> > ------------------------------------------------------
> > Error Is:
> > Message: ISC ERROR CODE:335544343
> >
> > ISC ERROR MESSAGE:
> > invalid request BLR at offset 250
> > function SUBSTR is not defined
> > module name or entrypoint could not be found
> >
> > STATEMENT:
> > TIBOInternalDataset: "dmIBODataModule_2.Query.IBOqrQuery."
> > ------------------------------------------------------
> >
> > I have tried various options -
> > Changed UDFAccess param in Firebird.conf.
> > Change to FULL, RESTRICT, commented also.
> > Nothing worked.
> >
> > One strange thing I found is -
> > If I rename the FBClient.dll to GDS32.dll in
> > c:\WinNT\System32 folder. it works.
> > Here my requirement is, I dont want to change the file name.
> >
> > Problem 2 -
> > When I keep FBClient.dll in application directory then
> > also UDFs doesnt work. same errro.
> >
> > Can anybody tell me is ther any issue in Firebird DB server
> > having differnt client dll file name(other than FBClient.dll) OR
> > placing the client library (FBClient.dll) in different folder.
> >
> > Can anybody please help me out.
> >
> > Thanks,
> > Bhavesh.
>
> you are using IBO. You probably need to take this to the IBO list.

Please

> confirm there if you have changed the client library refernce in

IBO before

> compiling.
> Alan

Thanks for the helping hand.

Here are some more details about the problem I am facing...

I am using external library.
The External UDF is registered in firebird DB.
This External library is copied in UDF directory in Firebird root
directory.

I am using IBO in delphi. And I have changed the referece from GDS32
to FBCleint.
It had connected also. But when I try to access any UDF it raises
error.

Thanks & Regards,
Bhavesh.