Subject | UDF, how to declare them |
---|---|
Author | Vander Clock Stephane |
Post date | 2011-01-24T19:23:05Z |
hello,
in IB_udf2 i see :
* Note: This function is NOT limited to
* receiving and returning only 255 characters,
* rather, it can use as long as 32767
* characters which is the limit on an
* INTERBASE character string.
DECLARE EXTERNAL FUNCTION ltrim
CSTRING(255) NULL
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_ltrim' MODULE_NAME 'ib_udf';
but when i try to do "select ltrim('...256chars...') from ... when i
receive an exeption numeric overflow ?
with 255 char it's ok !
did i do something wrong ?
in IB_udf2 i see :
* Note: This function is NOT limited to
* receiving and returning only 255 characters,
* rather, it can use as long as 32767
* characters which is the limit on an
* INTERBASE character string.
DECLARE EXTERNAL FUNCTION ltrim
CSTRING(255) NULL
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_ltrim' MODULE_NAME 'ib_udf';
but when i try to do "select ltrim('...256chars...') from ... when i
receive an exeption numeric overflow ?
with 255 char it's ok !
did i do something wrong ?