Subject | Re: [firebird-support] UDF call gives Invalid request BLR |
---|---|
Author | Nick Upson |
Post date | 2004-03-11T16:23:13Z |
Hi Alexander, thanks for the help.
I've deleted the udf for now but here is the def'n used to create it.
DECLARE EXTERNAL FUNCTION TITLECASE
CSTRING(256)
RETURNS CHAR(256) FREE_IT
ENTRY_POINT 'fn_titlecase'
MODULE_NAME 'udflocal';
NB. I did a backup under fb1 and then restored with 1.5
In article <c2pvf1+58cq@...>, Alexander V.Nevsky wrote:
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
I've deleted the udf for now but here is the def'n used to create it.
DECLARE EXTERNAL FUNCTION TITLECASE
CSTRING(256)
RETURNS CHAR(256) FREE_IT
ENTRY_POINT 'fn_titlecase'
MODULE_NAME 'udflocal';
NB. I did a backup under fb1 and then restored with 1.5
In article <c2pvf1+58cq@...>, Alexander V.Nevsky wrote:
> Nick, check--
>
> Select RDB$MODULE_NAME From RDB$FUNCTIONS
> Where RDB$FUNCTION_NAME='TITLECASE'
>
> there should be name of file where server tries to find it. If this
> name is wrong, update it. If in the old database module_name was
> registered with path, remove path, FB1 and FB1.5 have different ideas
> about their roor directory.
>
> Best regards,
> Alexander.
>
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly