--- In firebird-support@yahoogroups.com, "alanpltse" <alanpltse@...>
wrote:

>
> Hi Adam,
>
> I created the UDF by the scripts with no error:
> DECLARE EXTERNAL FUNCTION ADDYEAR
> DATE,
> INTEGER
> RETURNS DATE BY VALUE
> ENTRY_POINT 'IB_UDF_AddYear' MODULE_NAME 'ib_udf'
>
> So I assume Firebird knows where 'IB_UDF_AddYear' and 'ib_udf' are.
>
> But it only happens when I create the stored procedure, it seems not
> related to the date format.
>
> As the error message pointed to the entry_point and module_name.
>
> Besides using UDF, any way inside the stored procedure can add 100
> years to the date ?
>
> Alan

Perhaps using extract keyword you could reduce it to the elements then
combine it somehow. Out of curiousity, how do you intend on handling
leap years and days from previous centuries where people did not agree
on the date because they didn't want to switch calendars?

+1 adds a day, so providing you know how many days you want to add, it
is pretty simple.

Adam