Subject TO_CHARD Error (Udf4ORA UDF function)
Author Panos Bairaktaris
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]