Subject | Re: Problems using UDF and Firebird Embedded |
---|---|
Author | tmmcaravaca |
Post date | 2006-09-25T17:27:14Z |
Hi,
In the file ib_udf.sql the external lower function is declared as:
DECLARE EXTERNAL FUNCTION lower
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
I thought that this was enough, but I can't use the lower function.
I've resolved this including this declaration on the database file, is
this really necessary?
I'm using a standard directory distribution with a default
firebird.conf file:
c:\my_app\fbembed.dll
c:\my_app\ib_util.dll
c:\my_app\firebird.conf
c:\my_app\firebird.msg
c:\my_app\test.fdb
c:\my_app\intl\fbintl.dll
c:\my_app\udf\fbudf.dll
c:\my_app\udf\fbudf.sql
c:\my_app\udf\ib_udf.dll
c:\my_app\udf\ib_udf.sql
Thanks.
In the file ib_udf.sql the external lower function is declared as:
DECLARE EXTERNAL FUNCTION lower
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
I thought that this was enough, but I can't use the lower function.
I've resolved this including this declaration on the database file, is
this really necessary?
I'm using a standard directory distribution with a default
firebird.conf file:
c:\my_app\fbembed.dll
c:\my_app\ib_util.dll
c:\my_app\firebird.conf
c:\my_app\firebird.msg
c:\my_app\test.fdb
c:\my_app\intl\fbintl.dll
c:\my_app\udf\fbudf.dll
c:\my_app\udf\fbudf.sql
c:\my_app\udf\ib_udf.dll
c:\my_app\udf\ib_udf.sql
Thanks.