Hi,

> 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."
> ------------------------------------------------------

To where did you copy the External Function library on the server?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com