Thank you very much for the reply,
Indeed, it was the parameters, I think I fixed it now.
Panos.

----- Original Message -----
From: legrand_legrand_63
To: firebird-support@yahoogroups.com
Sent: Friday, February 23, 2007 8:05 PM
Subject: [firebird-support] Re: TO_CHARD Error (Udf4ORA UDF function)


--- In firebird-support@yahoogroups.com, "Panos Bairaktaris"
<panoramix95@...> wrote:
>
> Hi,
> I've installed these UDF funcitons from
http://perso.orange.fr/Udf4ORA/ in Firebird 1.5.
>
> DECLARE EXTERNAL FUNCTION TO_CHAR
> CSTRING(255)
> RETURNS CSTRING(255)
> ENTRY_POINT 'fn_to_char' MODULE_NAME 'rfunc';
>
> DECLARE EXTERNAL FUNCTION TO_CHARD
> TIMESTAMP,
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'fn_to_chard' MODULE_NAME 'rfunc';
>
> I have a CREATE VIEW statement that uses somewhere the TO_CHARD, and
parses ok:
>
> ----> to_chard(prod.start_date, 'MM/DD/YY')
>
>
> -but when I execute the SELECT * FROM aView i get this message :
>
> Statement failed, SQLCODE = -171
> function TO_CHARD could not be matched
>
> The prod.start_date is of type TIMESTAMP .
> What am i doing wrong here? Is changing to Firebird 2.0 gonna help?
> Thanks.
>
> [Non-text portions of this message have been removed]
>

Hello,

It seems you don't use the correct number of parameters ...
could you check that your view doesn't include something like:
TO_CHARD(prod.start_date)
without any format specification

Regards
PAscal





[Non-text portions of this message have been removed]