I get the error 'Token unknown -line 1, column 27 LPAD'.
I copied this function from UDF/ib_udf.sql.

Thank you, Alin

----- Original Message -----
From: Martijn Tonies
To: firebird-support@yahoogroups.com
Sent: Friday, June 13, 2008 7:09 PM
Subject: Re: [firebird-support] external function lpad


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






------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 270.3.0/1501 - Release Date: 6/13/2008 6:33 AM


--
I am using the free version of SPAMfighter for private users.
It has removed 196 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len


[Non-text portions of this message have been removed]