Subject | [firebird-support] UDF problems IB5.6 --> FB1.03 |
---|---|
Author | Paul Hope |
Post date | 2004-01-23T17:20:09Z |
Hi
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?
Regards
Paul
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?
Regards
Paul