where did you get udflib? did you develop your own lib?
otherwise - just use the FreeUDFLib for starters and use the accompanying
script to declare the functions enclosed. You'll save a lot of time.
it uses F_LRTRIM and requires only one argument.
I don't know what your arguments are trying to do here
Trim(2,'','2 4')

Alan

-----Original Message-----
From: cwkuok [mailto:benny@...]
Sent: Friday, 4 April 2003 8:40 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] construct the Trim UDF


when i try to construct the UDF using

DECLARE EXTERNAL FUNCTION trim
varchar(50)
RETURNS CHAR (40) FREE_IT
ENTRY_POINT 'fn_trim' MODULE_NAME 'udflib';

i could declare successfully but when i use it on insert statement
e.g.
INSERT INTO "UDF2" ("ID", "FIELD_1") VALUES (1, Trim(2,'','2 4'));
the ib-console prompt me error on module name or entrypoint could not
be found....

could anyone know how to solve it?



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/