Subject | TO_CHARD Error (Udf4ORA UDF function) |
---|---|
Author | Panos Bairaktaris |
Post date | 2007-02-22T14:49:41Z |
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]
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]