Alin,

> i'm using Firebird 2.1.0.17798.
>
> I declared in a database the following function:
>
> DECLARE EXTERNAL FUNCTION RTRIM
> CSTRING (255)
> RETURNS CSTRING (255) FREE_IT
> ENTRY_POINT 'IB_UDF_rtrim' MODULE_NAME 'ib_udf';
>
> and it worked!
>
> I can't understand why the next one doesn't work!
>
> DECLARE EXTERNAL FUNCTION lpad
> CSTRING(255) NULL, INTEGER, CSTRING(1) NULL
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_lpad' MODULE_NAME 'ib_udf';
>
> Can somebody help me to declare this function?
> Thank you, Alin

You're not telling us the error message. Could it be that LPAD
is an internal function?

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