Subject | Re: [firebird-support] UDF problems IB5.6 --> FB1.03 |
---|---|
Author | Helen Borrie |
Post date | 2004-01-24T01:19:53Z |
At 05:20 PM 23/01/2004 +0000, you wrote:
6. It affects a lot of the functions in that lib. Long ago, the FreeUDFLib
was updated to reflect that. You can download it from ibphoenix or from
Claudio's site www.cvalde.net
/heLen
>HiYes: these functions involve data types that changed between IB 5.6 and IB
>
>I am just starting to play with moving my databases from IB5.6 to FB.
>Stumped at the first post :-/
>
>I backed up the database using IB5.6 on server1.
>
>I installed FB1.03 on server2 and copied accross FreeUDFlib.dll (which also
>contains my udfs) into the bin directory.
>
>I copied the backed up database and restored it using FB.
>
>I got warnings that the entry point could not be found for 2 of my (many)
>UDFs. These are declared as
>
>DECLARE EXTERNAL FUNCTION F_ADDYEAR
> TIMESTAMP,
> INTEGER
> RETURNS TIMESTAMP FREE_IT
> ENTRY_POINT 'AddYear' MODULE_NAME 'FreeUDFLib.dll'^
>
> and
>
>DECLARE EXTERNAL FUNCTION F_NUMTOMONEYSTR
> DOUBLE PRECISION
> RETURNS CSTRING (12) FREE_IT
> ENTRY_POINT 'NumToMoneyStr' MODULE_NAME 'FreeUDFLib.dll'^
>
>There is no problem restoring under IB5.6. The two functions are visible in
>FreeUDFLib using QuickView.
>
>Any idea why it should pick on these two and what I can do about it?
6. It affects a lot of the functions in that lib. Long ago, the FreeUDFLib
was updated to reflect that. You can download it from ibphoenix or from
Claudio's site www.cvalde.net
/heLen